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
- 8 Answers
- 10047 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sree
3 rows
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explian rowid, rownum? What are the psoducolumns we have?
What is rownum?
What does closing a cursor do?
Why is normalization important?
What is the limitation on the block size of pl/sql?
Explain spool.
How do you update a table in sql?
What is full join in sql?
Explain what is a database?
How delete all data from table in sql?
Why use truncate instead of delete?
What is bitemporal narrowing?
Differentiate between pl/sql and sql?
What is null in pl/sql?
What is sql*loader and what is it used for?
