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

Notifications

IIFL Finance

How to delete duplicate rows form a table?

Anonymous

Feb 24, 2019

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

Anonymous

Sep 7, 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