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

…