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 / kapil
It would return 4 rows
because there is also a sum of ice_cream_sales for null also
so it would return 4 rows including null with order
dependimg on the value of sum function returned .
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are sql functions? Describe in brief different types of sql functions?
How can I delete duplicate rows?
What are aggregate functions in sql?
What is a record in pl/sql?
How do I copy a table in sql?
explain access control lists. : Sql dba
What is trigger and stored procedure in sql?
How to use sql*plus built-in timers?
How to select 10 records from a table?
What program will open a mdb file?
What is normalization? How many normalization forms are there?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What are transaction and its controls?
Is hadoop a nosql?