Exam TDA-C01 topic 1 question 78 discussion

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.

right answer