第1个回答 2013-12-18
以sCardNum分组,取出最大时间的记录
select * from cards where srcvouchdate in (select MAX(srcvouchdate) from UserList group by sCardNum)
第2个回答 2017-08-05
select * from cards a
where not exists
(select 1 from cards where acardnum=a.acardnum and srcvouchdate>a.srcvouchdate)
本回答被网友采纳
第3个回答 2013-12-18
selecct ct.* from (select sCardNum num,max(日期列) dt from cards group by sCardNum) tmp left join cards ct on ct.sCardNum= tmp.num and ct.日期列=tmp.dt
第4个回答 2013-12-18
select * from cards a
where not exists
(select 1 from cards where acardnum=a.acardnum and srcvouchdate>a.srcvouchdate)本回答被提问者采纳
第5个回答 2013-12-18
select * from cards where scardnum in(select scardnum,max(srcvouchdate) from cards group scardnum);