ROWNUM¶
The ROWNUM command adds a column labeled “rownum” with an automatically increasing unique sequential row-number, based on the number of rows that have been passed through in the query. This is useful, if you wish to create a unique ID on the output of the query you are working with.
Note that this command may have unexpected behaviour if used with nested queries, as the output of the nested queries are also given row numbers.
Usage¶
gor ... | ROWNUM