forum

Home / DeveloperSection / Forums / Delete duplicate rows in SQL.

Delete duplicate rows in SQL.

Sunil Singh 1269 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

Can you answer this question?

Answer

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.