-------------单列-----------------------
SELECT
检查字段,
COUNT(检查字段)
FROM
table_name
GROUP BY 检查字段
HAVING COUNT(检查字段) > 1
单列的容易理解,当多列重复才算重复时,如何处理?
-------------多列------------------
SELECT
检查字段1, COUNT(检查字段1),
检查字段2, COUNT(检查字段2),
...
FROM
table_name
GROUP BY
检查字段1,
检查字段2, ...
HAVING
(COUNT(检查字段1) > 1) AND
(COUNT(检查字段2) > 1) AND ...
原来是通过group by 多个条件,having 多个条件实现的
顺便温习下group by用法