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

Pergunta de entrevista da empresa Cognizant

Resposta da entrevista

Empresas seguidas

Buscas de vagas