Find dupicates records using groupby

 SELECT 

    EmployeeNumber, 

    COUNT(*) as CountOfDuplicates

FROM 

    profiles

GROUP BY 

    EmployeeNumber

HAVING 

    COUNT(*) > 1;