forum

home / developersection / forums / delete duplicate rows in sql.

Delete duplicate rows in SQL.

Sunil Singh 1504 24-Nov-2017

I am facing a problem in Sql. By mistake I have inserted some duplicate record. I want to delete all duplicate record ,

Can anyone tell me the query ,,,

database sql server

Updated on 25-Nov-2017

Other

25-Nov-2017

Use this query

with SalaryCTE AS

(

select *, ROW_NUMBER() over (partition by id order by id) as rownumber from salary

)

DELETE from SalaryCTE where rownumber >1

It helps you.