小隐的博客

摘要： 方法一：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 阅读全文