SQL_RANK_DENSE

This is a document Template

row : 1

SQL :

RANK: Considers the first row from the conflicting rows

SELECT RANK(950) WITHIN GROUP (ORDER BY sal DESC) "Rank" FROM emp

DENSE_RANK: Records the rows with similar ranking and reports as a parallel/join rank

SELECT DENSE_RANK(950) WITHIN GROUP (ORDER BY sal DESC) "Rank" FROM emp

DENSE_RANK ( COUNT IS ZERO BASED) , 950 DESC RANKED 11TH

DENSE_RANK 950 ASCS, IS 2ND (ZERO BASED)

RANK