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
- 12330 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
Do we need to create index on primary key?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is an ndf file?
Is oracle and sql same?
Does group by remove duplicates?
Describe sql comments?
Where not exists in sql?
How does index help in query performance?
What is structural independence and why is it important?
How do I truncate a sql log file?
how to concatenate two character strings? : Sql dba
What is nvarchar in sql?
What are the different dcl commands in sql?
What are the string functions in sql?
What is bind reference and how can it be created?
