代码示例 SELECT * FROM 表名 (字段1,字段2) IN (SELECT 字段1,字段2 FROM 表名 GROUP BY 字段1,字段2 HAVING COUNT(*)>1) ORDER BY 字段1;