In the TOP 10 with ROW_NUMBER example, what are the Ranking values for the first two records?

• A. 0 and 1
• B. 1 and 2
• C. 2 and 3
• D. 1 and 1

Answer: (B)

ROW_NUMBER() assigns a unique, consecutive integer to each row in the result, starting at 1 for the first row in the specified order. In a TOP 10 with ROW_NUMBER example, the first row is given 1 and the second row is given 2, since the numbering increments by 1 as you go down the ordered list. This is different from functions like RANK, which can produce same numbers for ties. So the first two records have ranking values 1 and 2.