Apache Tajo - rank()

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

Query

select rank() over (order by name) as rank from mytable;    

Result

The above query will generate the following result.

rank 
------------------------------- 
1 
2 
3 
4 
5 
6
7 
8 
9 
10  

The query returns the rank of the current row which is order by name.