Select T1.* from A T1 Inner Join (Select max(shijian) As shijian,yh_id from a group by yh_id ) T2 On T1.shijian=T2.shijian And T1.yh_id=T2.yh_id order by T1.yh_id asc
Select T1.shijian,T1.flag,T1.guzhang,T1.[order] from A T1 Inner Join (Select max(shijian) As shijian,yh_id from a group by yh_id ) T2 On T1.shijian=T2.shijian And T1.yh_id=T2.yh_id order by T1.yh_id asc
Select T1.* from A T1 Inner Join
(Select max(shijian) As shijian,yh_id from a group by yh_id ) T2
On T1.shijian=T2.shijian And T1.yh_id=T2.yh_id
order by T1.yh_id asc
Select T1.shijian,T1.flag,T1.guzhang,T1.[order] from A T1 Inner Join
(Select max(shijian) As shijian,yh_id from a group by yh_id ) T2
On T1.shijian=T2.shijian And T1.yh_id=T2.yh_id
order by T1.yh_id asc
你写的是对的,我怎么没有想到用INNER JOIN呢!谢谢!