Pergunta de entrevista da empresa IIFL Finance
How to delete duplicate rows form a table?
Respostas da entrevista
Sigiloso
7 de set. de 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