Monday, 26 January 2015

Delete Duplicate Rows in SQL Table

Suppose you have a table and in that table there is this type of duplicate entry then you will have to remove one of entry.
Then You can do it by this command

Delete Top(1) form table_name where id=1