Find and Delete duplicate records in a table

{ Published by chandrasekhar - On 6:00 PM - 0 comments }
Many times you can face problem of duplicate records in table.So How would you identify and delete duplicate records in a table? 
For that Firstly check if table has duplicate records or not using below query. 

Query :

SELECT [FirstName] FROM tblTest GROUP BY [FirstName] HAVING COUNT(*) > 1

Then Delete duplicate records.

DELETE FROM tblTest WHERE ID NOT IN (SELECT MAX(ID) FROM tblTest GROUP BY [FirstName])