mysql 查询重复的记录

?

1 2 3 4 5 6 7

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