Delete Duplicate Records from a Table in SQL Server

This code snippet is SQLl quert to delete all duplicate records from a table in sql server.

The requirement is very common. Many times we have to delete duplicate records from a table. Here there are many solutions for same problem:

Method 1

Create table NewTempTable as select distinct * from table_name;
Drop table table_name;
Rename NewTempTable  to table_name;

Method 2

Delete from <Table_Name> where <id> not in ( select max <id> from <table_Name> group by <duplicate_column>)

Both solutions are fine and solve the problem but second solution solves in one single SQL command.