How will you delete duplicate records/rows from a database table?

We can use the following query

select distinct * into #temptable
from mainTable

truncate table mainTable

insert mainTable
select *
from #temptable

drop table #temptable