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
12683 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 java sql drivermanager?

1104

What is a null value?

1150

What makes a good primary key?

1051

Does pl sql work in mysql?

987

What is vector point function?

1057

What are literals in sql server?

1178

What is the difference between inner join and outer join?

1002

What is a database trigger?

1073

What is record data type?

920

What is an inconsistent dependency?

1051

What is informix sql?

985

What does := mean in pl sql?

1047

How to run sql functions in pl/sql?

1060

What is rownum and rowid?

1039

How can you load multi line records? : aql loader

1083