Tag: row_number
-
Remove Full Duplicates by Using row_number() Function and Common Table Expression
This blog article is inspired by another very informative one which explains really well the meaning of the new row_number() function introduced since SQL2005. Since the original article did not give a full answer to how to delete multiple fully duplicated rows in a table, I am putting my code here for the test. The good…