IIFL Finance Interview Question: How to delete duplicate rows form a table?

Notifications

IIFL Finance

How to delete duplicate rows form a table?

Anonymous

7 Sept 2018

WITH cte AS ( SELECT empid , name , row_number() OVER(PARTITION BY empid , name order by empid ) AS [rn] FROM dbo.Emp ) DELETE cte WHERE [rn] > 1

Anonymous

24 Feb 2019

Delete from emp where Id in (select id emp group by e id having count (*)>1