SELECT flavor, SUM (ice_cream_sales) FROM sales_detail
GROUP BY flavor ORDER BY 2 DESC
If the "sales_detail" table contains ten records with
different values in the flavor column (two "vanilla,"
three "chocolate," four "strawberry," and one NULL), how
many rows are returned by the sample code above?
1. 0 rows
2. 1 row
3. 3 rows
4. 4 rows
5. 10 rows
Answers were Sorted based on User's Feedback
Answer / tulsi
four rows will be returned displaying null as the last row
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / gvmahesh
4 rows
1.vanilla
2.chocolate
3.strawberry
4.null
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / shilpa.oracle
3 Rows.
Because group functions ignore NULL values.
flavour sum(ice_cream_sales)
vanilla 10
chocolate 27
strawberry 8
Is This Answer Correct ? | 2 Yes | 5 No |
What is oracle pl sql developer?
What is dml with example?
What is the difference between functions, procedures, and packages in pl/sql?
Does sql profiler affect performance?
How can I pass the inner procedure value to outer procedure ?
What is constant in pl sql?
What is record in pl sql?
What is optimistic concurrency control? : Transact sql
What is the difference between cluster and non-cluster index?
what is the difference between to_char and to_date functions?
Is clustered index a primary key?
How to execute OS(operating system) command from pl/sql?