oracle中重复记录只取其中一条
select * from table1 where rowid=any(select max(rowid) from table1 group by field1)
或者
select * from table1 where rowid in (select max(rowid) from table1 group by field1)
oracle 数据重复,只取一条
最新推荐文章于 2024-04-07 11:14:24 发布