How to count Duplicate Rows in a Table

Hi,

I have a employee table I want to Count how many duplicate rows in my employee table 

Please Share Count Query 

 

 

 

 

 

 

 

 

 

 

 

 

By      09-Sep-2023    2

Solutions

Rizwan Saqib

Select  Count( EmployeeName )From Employee

Group By EmployeeName

Having Count(EmployeeName)>1

Your Answer

10038