Apache Tajo - row_number()

Let us now check the row_number() function with the following query.

Query

sampledb> select *,row_number() over (order by name) as rowno from mytable;    

Result

The above query will generate the following result.

The query assigns the row number for each row in the table.