ROWNUM()

Purpose

Function to return a number indicating the order in which the rows are selected from the table

Syntax

ROWNUM()

See Also

CURSYNCNUM(), PSEUDO COLUMNS, RECNO(), INSERT, SELECT, UPDATE, SYNCNUM()

Description

The ROWNUM() function returns a number indicating the order in which the rows are selected from the table. This can be contrasted with the physical row number in the table.

Example

OPEN DATABASE southwind
SELECT rownum(), recno(), state from example where state = "MA"