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 / tulsi
four rows will be returned displaying null as the last row
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Explain the savepoint statement.
What is the difference between an inner and outer join?
Is pl sql a programming language?
Why indexing is needed?
How to write pl sql program in mysql command prompt?
Can we use distinct and group by together?
what is union, minus and interact commands? : Sql dba
how do you know the version of your mysql server? : Sql dba
what is difference between delete and truncate commands? : Sql dba
What is identity column in sql server?
what are the different type of sql's statements ? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
What is a memo field?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Does truncate require commit?