1.oracle查找表中的重复数据
select testid,count(1)
from table
group by testid
having count(1)>1;
testid 标签号
2.去重
detele from tab_name a
where col1,col2 in(
select col1,
col2
from tab_name
group by col1,col2
having count(*)>1);