How to count Duplicate Rows in a Table Ask Question
Solutions

Rizwan Saqib
Select Count( EmployeeName )From Employee
Group By EmployeeName
Having Count(EmployeeName)>1
Hi,
I have a employee table I want to Count how many duplicate rows in my employee table
Please Share Count Query
Select Count( EmployeeName )From Employee
Group By EmployeeName
Having Count(EmployeeName)>1
Enter an email address to invite a colleague or co-author to join you on socimo. They will receive an email and, in some cases, up to two reminders.