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
12578 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 offset and limit in sql?

1038

How can triggers be used for the table auditing?

1049

What is raid? How does it help storage of databases?

1067

What are sql triggers used for?

980

What are the main features of cursor?

1066

what is myisam? : Sql dba

1055

What is the purpose of normalization?

1033

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

981

What is execution plan in sql?

1021

Enlist the advantages of sql.

986

Which are the different character-manipulation functions in sql?

1039

what is the difference between clustered and non clustered index in sql? : Sql dba

1107

Is primary key always clustered index?

993

What is latest version of sql?

1028

What is the difference between subquery and correlated query?

1043