select * from table a where a.date in (select max(b.date) from table b where b.id=a.id)
sql 查询相同记录下日期最大的 一条
最新推荐文章于 2023-08-31 14:28:43 发布
select * from table a where a.date in (select max(b.date) from table b where b.id=a.id)