ROWNUM
Syntax
ROWNUM()
Description
ROWNUM generates sequential numbers from one to the number of records. The number for the first record is one, two for the second record, and so on
*
The maximum number of records that ROWNUM can handle is two billion.
Copyright IBM Corporation 2013. All Rights Reserved.