select * from table where rowid in (select max(rowid) from table group by filed1,filed2,filed3)
SQL重复数据查询一条数据
最新推荐文章于 2023-12-14 15:26:22 发布
select * from table where rowid in (select max(rowid) from table group by filed1,filed2,filed3)