提取重复数据
SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) > 1
过滤重复数据
SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) = 1
提取重复数据
SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) > 1
过滤重复数据
SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) = 1