Wednesday, April 1, 2015

Find Duplicate Records in SQL Table




SELECT User_ID, COUNT(1) as CNT
FROM CHR_EmployeesMaster
GROUP BY User_ID
HAVING COUNT(1) > 1;

No comments:

Post a Comment