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
- 12892 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 acid property in database? : Sql dba
What is difference between table and view?
What are inner outer left and right joins in sql?
What are the different ways to optimize a sql query?
What does pl sql developer do?
What is partition in sql query?
Explain foreign key in sql?
What is the difference between count 1 and count (*) in a sql query?
What is $$ in sql?
What view means?
What are sql queries used for?
Why we use pl sql?
How do I find duplicates in a single column in sql?
Is left join and outer join same?
How many indexes can be created on a table in sql?
