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

Sign in to queue

Description

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:

Day:

2

Code:

DAT10-INT

The Discussion

Add Your 2 Cents