SAP
E_HANAAW_16 · Question #189
E_HANAAW_16 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock E_HANAAW_16 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
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
Unlock E_HANAAW_16 to see the answer
You've previewed enough free E_HANAAW_16 questions. Unlock E_HANAAW_16 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.