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

Frage im Vorstellungsgespräch bei Cognizant

Antwort im Vorstellungsgespräch

Beobachtete Unternehmen

Jobsuchen