-- 查找重复记录
select names,num
from test
where rowid != (select
max(rowid)
from test b
where b.names = test.names
and
b.num = test.num)
或者使用
select names,num
from test
where rownum!= (select max(rownum)
from test b
where b.names = test.names
and
b.num = test.num)