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

No media available

The recording for this session is not yet available

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:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.