挑选出number最大的select * from biao b where not exists(select * from biao where b.name=name and b.number<number) order by id desc挑选出时间最近的select * from biao b where not exists(select * from biao where b.name=name and b.eventtime<eventtime ) order by id desc
oracle sql 重复记录 只显示一条 ,显示 时间最近 或id 最大,同时显示其他列
最新推荐文章于 2022-06-17 09:40:08 发布