Ranking Functions

Numbering of rows in accordance with the order of values of a primary key

Numbering of a query result set

About ranking functions

New sql features

Numbering rows when there are duplicates in the results column

Numbering of a query result set

RANK() and DENSE_RANK() functions

About ranking functions

NTILE function

About ranking functions