How to delete duplicate rows form a table?

Question

How to delete duplicate rows  form a table?

Rajesh · Accepted 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

Sujit Kumar Mishra · Answer

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

IIFL Finance

Pregunta de entrevista de IIFL Finance

Respuestas de entrevistas

Empresas seguidas

Búsquedas de empleo