Question

Oracle中对表中每个字段都做查重该如何写

Answer 1

列出所有栏位:栏位1,栏位2,栏位3......
select 栏位1,栏位2,栏位3,count(*)
from user_table
group by 栏位1,栏位2,栏位3
having count(*)>1;

Answer 2

使用distinct去重
select distinct col1, col2, col3 from tab;