SQL Functions, Operators, Expressions, and Predicates : Ordered Analytical/Window Aggregate Functions : ROW_NUMBER
  
ROW_NUMBER
ROW_NUMBER function.
Purpose
Returns the sequential row number, where the first row is number one, of the row within its window partition according to the window ordering of the window.
Type
ANSI SQL:2011 window function.
Syntax
Syntax Elements
ANSI Compliance
Window Aggregate Equivalent
Example
Related Topics
Ordered Analytical/Window Aggregate Functions