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
Answer Posted / sree
3 rows
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is coalesce in sql?
How do you respond to dementia behavior?
How many databases can sql express handle?
How to look at the current sql*plus system settings?
What is the command used to fetch first 5 characters of the string?
What is a recursive stored procedure?
Why are indexes and views important to an organization?
Why is nosql good?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Which is faster subquery or join?
What are the three forms of normalization?
What does the hierarchical profiler does?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is embedded sql with example?
what is the difference between delete and truncate statement in sql? : Sql dba