How to delete duplicate rows form a table?

Question

How to delete duplicate rows  form a table?

Sujit Kumar Mishra · Accepted Answer

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

Rajesh · Answer

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

IIFL Finance

Domanda di colloquio di IIFL Finance

Risposte di colloquio

Aziende seguite

Ricerche di lavoro