rownumber

Returns the SELECT statement result row number beginning at 1

Syntax

rownumber()

Description

This function returns the number of the current result row for the executing SELECT statement.

Example

open bookshop;
select rownumber(), * from acctmgr;
         rownumber() mgrid   name                     hire_date   commission
                   1 ALFRED  Kralik, Alfred           1997-07-02       0.025
                   2 AMY     Zonn, Amy                1994-07-06       0.025
                   3 BARNEY  Noble, Barney            1972-05-08       0.035
                   4 FRANK   Doel, Frank              1987-02-13       0.030
                   5 JOE     Fox, Joe                 1998-12-18       0.025
                   6 KATE    Kelly, Kathleen          1998-12-18       0.025
                   7 KLARA   Novac, Klara             1990-01-02       0.025