Microsoft
70-433 · Question #85
70-433 Question #85: Real Exam Question with Answer & Explanation
The correct answer is D. ROW_NUMBER. ROW_NUMBER returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
Question
You need to write a query that uses a ranking function that returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. Which Transact-SQL statement should you use?
Options
- ARANK
- BNTILE(10)
- CDENSE_RANK
- DROW_NUMBER
Explanation
ROW_NUMBER returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
Community Discussion
No community discussion yet for this question.