Mysql查询多个字段重复的值

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