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






1.DENSE_RANK(): doesn't skip numbers after each tie
2.Have both the RANK and DENSE_RANK functions