T-SQL’s Magic Wand: The ROW_NUMBER Function (repeats on 6/8 at 6:45pm)


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.
For more information, check out this course on Microsoft Virtual Academy:





The Discussion

Comments closed

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.