In the SQL example, what are the Ranking values for the first two records?

In the SQL example, what are the Ranking values for the first two records?

• A. 0 and 1
• B. 1 and 1
• C. 1 and 2
• D. 10 and 9

Answer: (C)

Ranking with window functions assigns a position to each row based on the ORDER BY clause inside OVER. The first row gets 1, the second gets 2, and so on when there aren’t ties that alter the sequence. In the given example, the top two records have distinct sort values, so their ranking appears as 1 for the first row and 2 for the second. If there were ties for the top value, a true RANK would show 1 and 1 for the first two, with a gap before the next rank, whereas ROW_NUMBER would still yield 1 and 2 because it’s a strict sequential numbering. The 1 and 2 outcome thus reflects a non-tied, consecutive ranking for the first two records.

Ranking with window functions assigns a position to each row based on the ORDER BY clause inside OVER. The first row gets 1, the second gets 2, and so on when there aren’t ties that alter the sequence. In the given example, the top two records have distinct sort values, so their ranking appears as 1 for the first row and 2 for the second. If there were ties for the top value, a true RANK would show 1 and 1 for the first two, with a gap before the next rank, whereas ROW_NUMBER would still yield 1 and 2 because it’s a strict sequential numbering. The 1 and 2 outcome thus reflects a non-tied, consecutive ranking for the first two records.