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 are the packages in pl sql?
Why do we use partitions in sql?
What are the different parts of a package?
What is group by in sql?
Types of joins?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
How to display the contents of a current record fetched in a reference cursor?
What is break?
How is a process of pl/sql compiled?
Which table is left in join?
What are wait events. Describe the wait event tables.
What is memory optimized?