Difference between revisions of "ROWNUM()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
 
''Note: The ROWNUM Pseudo Column has been replaced with the ROWNUM() function.''
 
''Note: The ROWNUM Pseudo Column has been replaced with the ROWNUM() function.''
 +
  
 
==Purpose==
 
==Purpose==

Revision as of 15:09, 4 July 2011

Note: The ROWNUM Pseudo Column has been replaced with the ROWNUM() function.


Purpose

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


Syntax

ROWNUM()


See Also

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


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"


Products

Recital, Recital Server