SQL-实现统计重复值

代码

关于having与where

#查重
SELECT  列名 ,COUNT(列名)
FROM    表名
GROUP BY 列名
HAVING  COUNT(列名) > 1;

例子

#查重
SELECT  employee.employee_score ,COUNT(employee.employee_score) AS '次数'
FROM    employee
GROUP BY employee.employee_score
HAVING  COUNT(employee.employee_score) > 1;

根据employee.employee_score分组，然后过滤出次数大于1的。