How to delete duplicate rows in sql

Question

Cognos_Learner · Accepted Answer

First try to find the count of duplicate rows and then delete it except one record.
with Emp as 
(
select *, row_number()over(partition by ID order by ID) as rowcount 
from Employee
)
Delete from Emp where rowcount>1

Cognizant

Pregunta de entrevista de Cognizant

Respuesta de la entrevista

Empresas seguidas

Búsquedas de empleo