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 / gvmahesh
4 rows
1.vanilla
2.chocolate
3.strawberry
4.null
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the usage of when clause in trigger?
What is not equal in sql?
What is data profiling in sql?
What are the two types of exceptions in pl/sql?
How do I enable sql encryption?
What is the difference between delete and truncate commands?
define data blocks ? : Sql dba
how to convert dates to character strings? : Sql dba
What are analytic functions in sql?
how to get a list of all tables in a database? : Sql dba
What is sql lookup?
What is union and union all keyword in sql and what are their differences?
What is a table in a database?
how to present a past time in hours, minutes and seconds? : Sql dba
How to run sql statements through the web interface?