17,377
社区成员
发帖
与我相关
我的任务
分享
select * from t t1 where not exists (select 1 from t t2
where t1.kemu = t2.kemu and t1.qijian = t2.qijian and t1.jine = t2.jine
and t1.riqi < t2.riqi);
select 科目,期间,金额,max(日期)
from table1
group by 科目,期间,金额