Microsoft
70-433 · Question #108
You have the following table named Sales. You need to return sales data ordered by customer name and date of sale. For each customer, the most recent sale must be listed first. Which query should…
The correct answer is C. SELECT CustomerName. See the full explanation below for the reasoning.
Question
You have the following table named Sales. You need to return sales data ordered by customer name and date of sale. For each customer, the most recent sale must be listed first. Which query should you use?
Options
- ASELECT CustomerName,
- BSELECT CustomerName,
- CSELECT CustomerName,
- DSELECT CustomerName,
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C74% (23)
- D13% (4)
Community Discussion
No community discussion yet for this question.