oracle查询表内的重复数据，并删除重复数据

---查询重复数据：select *     from user_tab u      where u.aa003 in (select u.aa003         from user_tab u           group by u.aa003   having count(*) > 1)----删除重复数据：delete from user_tab   where aa003 in (select aa003 from     user_tab group by aa003 having count(aa003) > 1)       and rowid not in (select min(rowid) from         user_tab group by aa003 having count(aa003 )>1)