SELECT
EmployeeNumber,
COUNT(*) as CountOfDuplicates
FROM
profiles
GROUP BY
EmployeeNumber
HAVING
COUNT(*) > 1;
No comments:
Post a Comment