sqlbelle.wordpress.com
Deleting Duplicates using CTE and ROW_NUMBER Ranking Function
This is just a simple demonstration of how you can delete duplicates using CTE (Common Table Expressions) and the ROW_NUMBER() ranking function. Assume you have the following table called SampleTab…