数据库查重复值

以前处理故障时候，遇到特殊情况下，表中的数据出现重复，可以巧用rowid 处理重复数据create table test1(id integer,city varchar2(100),levle varchar2(4));select * from test1;insert into test1 values(1,'hangzhou','1');insert into test1 values(2,'binjiang','2');insert into test1 values(3,'chengxi','2');insert into test1 values(4,'yuhang','3');insert into test1 values(1,'hangzhou','1');insert into test1 values(2,'binjiang','2');insert into test1 values(3,'chengxi','2');insert into test1 values(4,'yuhang','2');select * from test1 where rowid in(         select min(rowid) from test1 group by id having count(1)>1)就找出了重复的数据，可以做删除 修改处理