Difference between revisions of "ROWNUM()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
|||
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Purpose== | ==Purpose== | ||
Function to return a number indicating the order in which the rows are selected from the table | Function to return a number indicating the order in which the rows are selected from the table | ||
− | |||
==Syntax== | ==Syntax== | ||
ROWNUM() | ROWNUM() | ||
− | |||
==See Also== | ==See Also== | ||
[[CURSYNCNUM()]], [[PSEUDO COLUMNS]], [[RECNO()]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]], [[SYNCNUM()]] | [[CURSYNCNUM()]], [[PSEUDO COLUMNS]], [[RECNO()]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]], [[SYNCNUM()]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 24: | Line 17: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Cursor Functions]] |
Latest revision as of 04:50, 7 December 2012
Contents
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"