Omnidex SQL Function: $CURRENT_ROW

Returns the current row as an ascending number from starting with 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.

$CURRENT_ROW

select $current_row, company from customers

$CURRENT_ROW   COMPANY
------------   -------------------------------------

1  Dynamic Information Systems Corporation

2  The Bovaird Supply Company

3  Graham Container Companies

...