Question

oracle查询表中字段里数据是否有重复

Answer 1

查看id列是否有重复
方法一：
select id,count(*) from 表 group by id having count(*)>=2;
方法二：
select count(*) from 表；
select count(*) from (select distinct * from 表);