The ROW_NUMBER function in Microsoft SQL Server is seemingly nothing more than a basic ranking calculation that assigns incrementing integers to the rows in the result set of a query. But in reality this function holds within it immense power waiting to be unleashed to address both performance and complexity aspects of solutions to querying problems. This session demonstrates an array of problems that can be handled with great efficiency and elegance by using the ROW_NUMBER function.
Event HomepageTech·Ed North America 2010
More episodes in this series
Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.