RANK_DENSE(SUM([Sales]))
The RANK_DENSE() function calculates a dense rank based on the sum of sales for each customer. A dense rank assigns a rank to each row, even if there are duplicate values. This means that the ranks will not skip any numbers, even if there are multiple customers with the same sales amount.
The RANK() function also calculates a rank based on the sum of sales, but it does not assign a rank to duplicate values. This means that the ranks may skip numbers.
The RANK_MODIFIED() function calculates a rank based on the sum of sales, but it assigns a rank to duplicate values by taking into account the number of duplicate rows. This means that the ranks will not skip any numbers, but they may not be in strict numerical order.
The ROW_NUMBER() function simply assigns a sequential row number to each row.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MonBouj
3 weeks, 6 days agomnnopen
3 months, 3 weeks ago