Windows function in SQL-Dense_rank vs Rank
8 September, 2020
1
1
0
Contributors
A windows function performs a calculation across a set of table rows that are somehow related to the current row.
The example of Dense_rank vs Rank:
Syntax of Dense_rank:
The following is the output of the syntax of Dense_rank:
Output of dense_rank
Syntax of rank:
The following is the output of the syntax of rank:
