- oracle查询重复数据
select * from test where id in (select id from test gruop by id having count(id)>1)
select * from test where id,name in (select id name from test gruop by id ,name having count(*)>1)
- oracle 重复数据删除,保留id最小的记录
delete from test where id,name in (select id name from test gruop by id ,name having count(*)>1) and rowid not in (select min(rowid) from test gruop by id ,name having count(*)>1)