SQL Query to Get Count of Duplicate Records:

SELECT Id,Name, COUNT(*) as DupeCount FROM EmployeData GROUP BY Id,Name HAVING COUNT(*) > 1 Order By Id

After run above query we will get each record duplicate count that would be like this

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email