How to delete duplicate records from a table in sql

hi smith,

You can use ROW_NUMBER() with PARTITION BY to delete duplicate.

Suppose you have emp table with duplicate records as:

and want emp after deletion of duplicate records as:

Use following CTE Query to delete duplicate record from the table emp:

Now execute select query again

result will be as:

Thanks...

Finally I got the solution.