In this article, I will show you the differences in using the row_number() function versus a correlated sub-select for filtering data. One thing that I have seen frequently is the use of the row_number() function to limit result sets. While row_number() has it's uses, using it to filter results is not necessarily one of them. There are several scenarios in which this is useful. Before setting up the test data and reviewing the results, I will explain a few scenarios that I have seen. Scenario...