SELECT 列名, COUNT(列名) as 数量 FROM 表名 GROUP BY 列名 HAVING COUNT(列名) > 1 转载于:https://www.cnblogs.com/jasonlai2016/p/10108120.html