Article will cover some best practices on how to delete duplicate rows in sql server table.
We’ll be using a student table. Query for the table creation
Inserted 4 rows into the table, row with roll Number one is repeated twice.
Query result will look like this
and shows that rollNumber with ‘1’ is repeated 2 times.
here I will be explaining two methods for deleting duplicate rows.
Method 1 – by keeping original
In this method all duplicate rows will be deleted except the original copy. Check this query
after deletion, student table will be shown as below
Method 2 – without keeping original
In this method all repeated rows including original copy will be deleted.
query
resulting table will be like this