Delete duplicate rows in SQL.

Sunil Singh 1630 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 ,,,

Sunil Singh

Other

Manish Kumar 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.

forum