3 Rows. Because group functions ignore NULL values. flavour sum(ice

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

Question Posted / shilpa.oracle

8 Answers
12329 Views
Sonata, I also Faced
E-Mail Answers

Answer Posted / shilpa.oracle

3 Rows.
Because group functions ignore NULL values.

flavour sum(ice_cream_sales)
vanilla 10
chocolate 27
strawberry 8

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is user defined functions?

918

What is a constraint? Tell me about its various levels.

1085

Is microsoft sql free?

1045

What are character functions?

1043

What is rtm in testing?

1040

What are the different ways to optimize a sql query?

891

Differentiate between pl/sql and sql?

1073

What does subquery mean in sql?

992

what is blob? : Sql dba

1056

How do you modify a column in sql?

943

What is using in sql?

1019

What is clustered and nonclustered index in sql?

896

what is primary key? : Sql dba

956

What sql database should I use?

1075

What is the difference between joins?

977