Difference between revisions of "ROWNUM()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) m (ROWNUM moved to ROWNUM()) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | ''Note: The ROWNUM Pseudo Column has been replaced with the ROWNUM() function.'' | ||
| + | |||
==Purpose== | ==Purpose== | ||
| − | + | 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== | ||
| − | [[PSEUDO COLUMNS]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | + | [[PSEUDO COLUMNS]], [[RECNO()]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] |
==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 | + | |
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | OPEN DATABASE southwind | |
| − | + | SELECT rownum(), recno(), state from example where state = "MA" | |
| − | + | ||
| − | SELECT | + | |
| − | + | ||
| − | + | ||
| − | + | ||
</code> | </code> | ||
| Line 33: | Line 28: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | [[Category: | + | [[Category:FUNCTIONS]] |
Revision as of 15:06, 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
