How to remove duplicate records from the table  

Thanks Aniket

Group by is better than inner join when dealing with big data

Thanks

Thanks Hareesh

Thanks Fazil

Thanks

Thanks

You can see the results

I want to remove the higher emploeeid records for the same employee ( if Mohan has two records at 2nd row and 4th row) - it will delete 4th row

how you decided 1000x?

Understood, as this simply purges all duplicate rows that are found within the where clause. But I would argue the database operations are quite similar because neither one sorts the data first. It would be interesting to see though if the inherent where exists function performs faster in general.

It depends what you consider to say your records duplicate

Use the truncate...but it will delete the entire record

That will return distinct results in the query, but the data still exists in the table

@@michaelbacchiocchi8111 thanks for clearing up the doubt.

Yes

Thanks