SQL表内查重,查询重复记录
select * from my_tab
where dup_col in(
select dup_col from my_tab
group by dup_col
having count(dup_col)>1
)
order by dup_col;
SQL表内查重,查询重复记录
select * from my_tab
where dup_col in(
select dup_col from my_tab
group by dup_col
having count(dup_col)>1
)
order by dup_col;