Window Function Dense_Rank()

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select mark1,mark2,mark3,dense_rank() over (order by age) as
   denserank from dfs.`/Users/../workspace/Drill-samples/student_list.json`;

Result

mark1 mark2 mark3 dense_rank
 70    50    60       1
 40    50    40       1
 60    80    70       1
 50    70    70       1
 70    60    65       1
 100   95    98       1
 90    85    95       1
 55    45    45       2
 75    85    90       2
 80    85    88       2