oracle数据库中怎样删除一个表的重复数据。 这个问题就是复要删除表中重复的记录制，查询的sql语句如下：select id，name fromselect id，name，row_numer()over(partition by id，name order by id，name)rn from tableA)where rn>；1；删除zhidao的sql语句如下：DELETE tableA WHERE ROWNUM=(SELECT ROWNUMFROM(SELECT id，name，ROW_NUMBER()OVER(PARTITION BY id，name ORDER BY id，name)RNFROM tableA)WHERE RN>；1)；
oracle查重复数据并显示出来 SELECT*FROM t_info aWHERE((SELECT COUNT(*)FROM t_infoWHERE Title=a.Title)>；1)ORDER BY Title DESC一。查找重2113复记录526141021。查找全部重复记录Select*From 表 Where 重复字段1653 In(Select 重复字段 From 表 Group By 重复字段 Having Count(*)>；1)2。过滤重复记录(只显示一条)Select*From HZT Where ID In(Select Max(ID)From HZT Group By Title)注：此处显示ID最大一条记录二。删除重复记录1。删除全部重复记录（慎用）Delete 表 Where 重复字段 In(Select 重复字段 From 表 Group By 重复字段 Having Count(*)>；1)2。保留一条（这个应该是大多数人所需要的^_^）Delete HZT Where ID Not In(Select Max(ID)From HZT Group By Title)注：此处保留ID最大一条记录1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断select*from peoplewhere peopleId in(select peopleId from people group by peopleId having count(peopleId)>；1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录delete from peoplewhere peopleId in(select peopleId from people group by 。
oracle的自连接如何去除重复的数据呢？ selectcase when AA.fhid>；BB.fhid then AA.fhid else BB.fhid end，case when BB.fhid>；AA.fhid then BB.fhid else AA.fhid end，AA.zhid，BB.zhidfrom(select a.fhid，b.zhid，a.dyfrom t_gg_fwxxfh a，t_gg_fwxxz b，t_mpb cwhere b.zhid=a.zhid and c.mpid=b.mpid)AA，(select a.fhid，b.zhid，a.dyfrom t_gg_fwxxfh a，t_gg_fwxxz b，t_mpb cwhere b.zhid=a.zhid and c.mpid=b.mpid)BBwhere AA.fhid。BB.fhid and AA.zhid=BB.zhid and AA.dy=BB.dygroup bycase when AA.fhid>；BB.fhid then AA.fhid else BB.fhid end，case when BB.fhid>；AA.fhid then BB.fhid else AA.fhid end，AA.zhid，BB.zhid仅限于当2113前两条数据使5261用，数据多了会导4102致前俩字段1653互换位置
