1.查找某一列的值(col:列名)
SELECT
col,
COUNT(col)
FROM
table_name
GROUP BY col
HAVING COUNT(col) > 1;
2.查找多列的值
SELECT
col, COUNT(col),
col1, COUNT(col1)....
FROM
table_name
GROUP BY col
HAVING COUNT(col) > 1
and COUNT(col1) > 1...;