delete duplicate rows in SQL

In this article, we will see how to delete duplicate rows from a table in SQL server. This is a very common SQL interview question. Here is the table with duplicate data, notice that Avinash record is duplicated 2 times Joe record 2 times and Nancy record 2 times. Now the delete query that we … Read more