mysql 查询重复的记录

SELECT * FROM workorder_role_skill
WHERE (roleCode, skillCode) IN (
    SELECT roleCode,skillCode FROM workorder_role_skill
        GROUP BY roleCode,skillCode
        HAVING count(1) > 1
        )
ORDER BY roleCode ASC,skillCode ASC