Microsoft
70-432 · Question #43
You are a database developer for your company. You are developing a sales report for a given time period. The report must list all sales representatives and their position based on their total sales…
The correct answer is A. RANK. See the full explanation below for the reasoning.
Question
You are a database developer for your company. You are developing a sales report for a given time period. The report must list all sales representatives and their position based on their total sales for the period. If two sales representatives had the same total sales, they should be assigned the same position. A sample output is shown in the following display. You need to create the report to fulfill the requirements. Which operator should you use?
Options
- ARANK
- BDENSE_RANK
- CNTILE
- DROW_NUMBER
How the community answered
(21 responses)- A81% (17)
- B5% (1)
- C5% (1)
- D10% (2)
Community Discussion
No community discussion yet for this question.