Ranking = ROW_NUMBER() OVER(PARTITION BY SalesOrderID ORDER BY LineTotal DESC), RankingWithRank = RANK() OVER(PARTITION BY SalesOrderID ORDER BY LineTotal DESC), RankingWithDenseRank = DENSE_RANK() ...
The RANK() function returns the same rank for the rows with the same values. It adds the number of tied rows to the tied rank to calculate the next rank. Therefore, the ranks may not be consecutive ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback