$CURRENT_ROW
Returns the current row as an ascending number from 1.
This number is assigned after all other clauses are processed.
This
function may only be used as a select-item. It may NOT be used in a WHERE
, GROUP BY, ORDER BY, or HAVING clause.
The return data type is integer length 4.
Syntax
$CURRENT_ROW
Example
select $current_row, company from customers
$CURRENT_ROW
------------ |
COMPANY
----------------------------------------
|
1 |
Dynamic Information Systems Corporation |
2 |
The Bovaird Supply Company |
3 |
Graham Container Companies |
... |
|
Top
|