write sql query to find duplicate rows in a database

Last Post

Posts: 18

jeevan 123

Topic starter

May 03, 2022 6:21 am

(@jeevan303500)

Active Member

Joined: 2 years ago

Here is the SQL query to find duplicate rows in a database.

Using common table expressions we can easily achieve this.

Example data scenario.

Input

ID name salary

1 ABC 1000

2 ABC 1000

3 BCD 2000

Output

ID name salary

1 ABC 1000

2 BCD 2000

SQL Query

 With EmpCTE as

        (

Select *, Rownumber() Over(Partition By ID order By ID) As Rownumber
        From Emp

        )
Delete from EmpCTE where Rownumber>1