How can we delete the duplicate data from a database table?

[smithanair]

We can use Common table Expression

;With empcte(id,sal,Ranking)
as
(Select id,sal,Ranking=Dense_Rank() over (Partition by id,sal
order by newid() asc) from employee)
Delete * from empcte where Ranking>1

Regards
Smitha