Delete Duplicate row in SQL Server

Home / SQL Server / Delete Duplicate row in SQL Server

Following below query help you to delete duplicate row in sql sever

 

DELETE A FROM table1 A 
	where %%physloc%% > (
      SELECT min(%%physloc%%) FROM table1 B
     WHERE A.ID= B.ID)


In SQL Server 2008, ROWID you can get through %%physloc%%,

edgedoll.com