SAP
E_HANAAW_16 · Question #189
In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY…
The correct answer is A. The CASE statement as provided in the SELECT list without its alias. See the full explanation below for the reasoning.
Question
In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?
Options
- AThe CASE statement as provided in the SELECT list without its alias
- BThe alias of the CASE construct used in the SELECT list
- CNone; the GROUP BY list is added automatically
- DThe name of the gross amount column that is used in the CASE statement
How the community answered
(29 responses)- A83% (24)
- B3% (1)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.