An analyst needs to assign a sequential rank to each sale within each sales region, ordered by sale amount descending, without gaps in the ranking when there are ties. Which window function should they use?

Question

Accepted Answer

B. DENSE_RANK(). DENSE_RANK() assigns sequential ranks without gaps. If two rows tie at rank 2, the next rank is 3, not 4. RANK() also assigns ranks by order but skips values after ties (ranks would be 1, 2, 2, 4). ROW_NUMBER() assigns unique sequential integers with no ties. NTILE() divides rows into N buckets and is not a ranking function.

An analyst needs to assign a sequential rank to each sale within each sales region, ordered by sale amount descending, without gaps in the ranking when there are ties. Which window function should they use?

Related Questions

Discussion