Question

oracle中统计重复几次的数据有几条

Answer 1

select a, count(1) from tab group by a
就可以找出a有几条记录

如果要找出多余一条的重复记录
select a, count(1) from tab group by a having count(1) >1

Answer 2

select a, count(1) from tab group by a
就可以找出a有几条记录

如果要找出多余一条的重复记录
select a, count(1) from tab group by a having count(1) >1

Answer 3

select 需统计的列,count(*) from 表名 group by 需统计的列 having count(*)=重复次数

Answer 4

select a, count(1) from tab group by a