SQL: Analytic Function RANK and DENSE_RANK
In this video, we will see analytic function RANK and DENSE RANK with practical example
RANK- This function assigns a same number with in the partition for the same value.
It skips the continuation of series.
Syntax:
RANK() OVER
( [PARTITION BY column1, ... ]
ORDER BY column1 [ASC | DESC], ... )
DENSE_RANK- This function assigns a same number with in the partition for the same value.
It does not skips the continuation of series.
Syntax:
DENSE_RANK() OVER
( [PARTITION BY column1, ... ]
ORDER BY column1 [ASC | DESC], ... )
Connect me on Instagram for any queries -
/ thisisanandyadav