Delete From TableName

Where ID Not IN

{

Select MAX(ID) From TableName

Group By Col1, Col2...

}

By The help of Table name useing ID and the Group By we can delete the duplicate record from table in sql server.

For more Interview question Click on billow link.

http://sqlserver4us.blogspot.in/[/url]