PLSQL 查重

1、列出某个字段重复的所有行：

select * from table where lID in (select lID from table group by lID having count(lID) > 1);

2、删除重复数据，留rowid最小的行：

delete from table where lid in (select lid from table group by lid   having count(lid) > 1) and rowid not in (select min(rowid) from  table group by lid having count(lid)>1)

3、查询名称重复：

Select Name,Count(*) From A Group By Name Having Count(*) > 1