Wednesday, 14 August 2024

Find dupicates records using groupby

 SELECT 

    EmployeeNumber, 

    COUNT(*) as CountOfDuplicates

FROM 

    profiles

GROUP BY 

    EmployeeNumber

HAVING 

    COUNT(*) > 1;

No comments:

Post a Comment

Best UI