Microsoft
70-433 · Question #136
Your database contains sales information for millions of orders. You need to identify the orders with the highest average unit price and an order total greater than 10,000. The list should contain…
The correct answer is B. SELECT TOP (20) o. See the full explanation below for the reasoning.
Question
Your database contains sales information for millions of orders. You need to identify the orders with the highest average unit price and an order total greater than 10,000. The list should contain no more than 20 orders. Which query should you use?
Options
- ASELECT TOP (20) o.
- BSELECT TOP (20) o.
- CSELECT TOP (20) o.
- DSELECT TOP (20) o.
How the community answered
(28 responses)- A11% (3)
- B71% (20)
- C4% (1)
- D14% (4)
Community Discussion
No community discussion yet for this question.