oracle如何查询不重复数据 可以把重复值e69da5e887aa3231313335323631343130323136353331333361323530删除，可参考：1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断select*from people where peopleId in(select peopleId from people group by peopleId having count(peopleId)>；1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录delete from people where peopleName in(select peopleName from people group by peopleName having count(peopleName)>；1)and peopleId not in(select min(peopleId)from people group by peopleName having count(peopleName)>；1)3、查找表中多余的重复记录（多个字段）select*from vitae a where(a.peopleId，a.seq)in(select peopleId，seq from vitae group by peopleId，seq having count(*)>；1)4、删除表中多余的重复记录（多个字段），只留有rowid最小的记录delete from vitae a where(a.peopleId，a.seq)in(select peopleId，seq from vitae group by peopleId，seq having count(*)>；1)and rowid not in(select min(rowid)from vitae group by peopleId，seq having count(*)>；1)5。
oracle中如何查询数据表中重复的数据？ 其实可以用很简单SQL语句将其查询出来。如果想查询数据表中某一个字段重复（这里假设这个字段名是ID1），可以使用以下SQL语句。select Table1.*from Table1 right join(select ID1 From Table1 Group by ID1 having Count(ID1)>；1)T on Table1.id1=T.id1 如果想查询数据表某两个字段重复，则可以使用如下语句查询。select Table1.*from Table1 right join(select ID1，ID2 From Table1 Group by ID1，ID2 having Count(ID1)>；1 and Count(ID2)>；1)T 注：上面代码中出现的ID1和ID2字段均不是数据表主键。
ORACLE数据库视图里面判断当某字段值重复就判断另一字段是否等于特定值，如何实现 如我有一个表tb_a，字段id，name，值ac-01，x ac-02，s ac-03，m 表tb_b 字段 fk c_value 值 。
