sql查询按两个字段查询重复记录

这样肯定有错的你看看IN （SELECT XM FROM SHIYAN003)一个IN只能一个字段。 SELECT COUNT(1) FROM SHIYAN003 A GROUP BY A.XM,A.SFZHM HAVING COUNT(1) > 1