Microsoft
70-433 · Question #80
You need to implement a common table expression (CTE). Which code segment should you use?
The correct answer is B. WITH SalesByYear(Year,Region,Total). See the full explanation below for the reasoning.
Question
You need to implement a common table expression (CTE). Which code segment should you use?
Options
- ACREATE VIEW SalesByYear
- BWITH SalesByYear(Year,Region,Total)
- CSELECT Year,
- DSELECT DISTINCT Year,
How the community answered
(28 responses)- A14% (4)
- B75% (21)
- C7% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.