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
- 10141 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
Can we commit inside a trigger?
What is sqlite format?
How can I change database name in sql?
What are the different datatypes available in PL/SQL?
What are the types of index in sql?
What makes a good primary key?
What sql database should I use?
What is the main difference between sql and pl/sql?
Show code of a cursor for loop.
What is implicit cursor in pl sql?
What is compute?
What is range partitioning?
Show how functions and procedures are called in a pl/sql block.
What is the use of sqlerrd 3?
Why truncate is used in sql?
