Remove Duplicate Record Form a Table in SQL

Use Partial Clause to remove duplicate records
delete from
(Select Colum1 , column2,

rownumber() over( partion by column1, column2

order by column1, Colum2
)Rowsnumbers
from DuplicatrecordTable) AliasTable

where AliasTable.Rowsnumbers>1

Reference:
sqlservercentral