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

Sollicitatievraag bij Cognizant

Antwoord op sollicitatievraag

Gevolgde bedrijven

Vacatures