oracle表欄位去重____oracle

單欄位去重
查看重複資料

select * from testrepeat t where t.id in (select id from testrepeat group by id having count(id) > 1);

重複資料刪除記錄，保留rowid最小的行

delete from testrepeat t where t.id in (select id from testrepeat group by id having count(id) > 1)   and rowid not in       (select min(rowid) from testrepeat group by id having count(*) > 1)

多欄位去重
查看重複資料

select * from testrepeat t where (t.id,t.phone) in (select id,phone from testrepeat group by id,phone having count(*) > 1);

重複資料刪除記錄，保留rowid最小的行

delete from testrepeat t where  (t.id,t.phone) in (select id,phone from  testrepeat group by id,phone having count(*) > 1)   and rowid not in       (select min(rowid) from testrepeat group by id,phone having count(*) > 1)