Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order number 1,2 & 3  have identical values. Now we need to delete the duplicate rows.   Step 1 : Insert another column in table Sample called  Dup of type Integer. Step 2 : Execute this Query… (0 comment)