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
12891 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

Differentiate between sga and pga.

1206

What is difference between sql and oracle?

1192

what is a database lock ? : Sql dba

1225

Does view contain data?

1084

What is difference between mysql and postgresql?

1233

What are the types of dbms?

1024

What is left join in sql?

1093

Which query operators in sql is used for pattern matching?

1011

What is the difference between sql and t sql?

1107

How do you copy a table in sql?

1109

Does group by remove duplicates?

1092

What are the two types of exceptions in pl/sql?

1090

Define sql delete statement.

1065

Why we use join in sql?

1024

What is a system versioned table?

1041