SQLServer查询某一列的重复值

SELECT * FROM TB_PDO WHERE COIL_NUMBER_IN IN (SELECT COIL_NUMBER_IN FROM TB_PDO GROUP BY COIL_NUMBER_IN HAVING COUNT(COIL_NUMBER_IN)>1) ORDER BY ID DESC