How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1);

WITH CTE AS (

    SELECT 

        Email,

        ROW_NUMBER() OVER (PARTITION BY Email ORDER BY (SELECT NULL)) AS RowNumber

    FROM Recruitment

)

SELECT * FROM CTE WHERE RowNumber > 1

--DELETE FROM CTE WHERE RowNumber > 1;