Built-in Functions → rowNumber

rowNumber() is a function that returns a sequential number of a row within an insight result set. The numbers only exist temporarily with the query results, and are not stored in the table.

Note

The rowNumber() function is only applicable for a tabular list report.

Signature

rowNumber()

Returns

int

Example

Add sequential numbering to the rows of a result set.

rowNumber()