Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12672 Views
- Sonata, I also Faced
- E-Mail Answers
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
What is the difference between sql and t sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the difference between mdf and ndf files?
What is the syntax and use of the coalesce function?
What is the most common sql injection tool?
Is nosql relational?
Which join condition can be specified using on clause?
How do I filter in sql profiler?
What are the two characteristics of a primary key?
what is top in tsql? : Transact sql
How to select unique records from a table?
Is sql open source?
Is truncate ddl or dml?
What is the difference between function, procedure and package in pl/sql?
What do you understand by pl/sql records?
