---查询重复数据:
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)