Skip to main content
Assigns a rank to each row within a partition based on the values in the specified column. When there are ties, the same rank is assigned but no gaps appear in the ranking sequence. Category: window Syntax: 
DenseRank([column])
Returns: Integer Context Filtering: ✗ No

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to rank by

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

DenseRank([Sales])
Returns the dense rank of each row based on sales values. If two rows tie for rank 2, both get rank 2, and the next row gets rank 3 (no gaps). 
DenseRank([Score])
Ranks rows by score values. Tied scores receive the same rank, with subsequent ranks continuing sequentially without gaps. Result: 1, 2, 2, 3, 4, 5, ...
  • Rank - Assigns rank with gaps
  • PercentRank - Calculates relative rank as percentage
  • RowNumber - Assigns sequential row numbers
  • CumeDist - Calculates cumulative distribution
  • Ntile - Divides rows into groups
Last modified on March 13, 2026