DENSE RANK « Analytical Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Analytical Functions
  3. DENSE RANK
1.DENSE_RANK(): doesn't skip numbers after each tie
2.Have both the RANK and DENSE_RANK functions