Microsoft
70-433 · Question #85
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…
Sign in or unlock 70-433 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.
Implement Programming Objects
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
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ROW_NUMBER#ranking functions#window functions#partition numbering