摘要:方法一:select * from s600520 awhere not exists (select 1 from s600520 b where a.CJDate =b.CJDate and b.CJTime >a.CJTime )order by CJDate方法二:select * from (select *,row_number() over(partition by CJDate order by CJTime desc) rid from s600520)as l where rid =1
阅读全文
posted @ 2012-01-11 14:33