Question d'entrevue chez IIFL Finance: How to delete duplicate rows form a table?

IIFL Finance

How to delete duplicate rows form a table?

Utilisateur anonyme

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

Utilisateur anonyme

24 févr. 2019

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