Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / suresh

Answers were Sorted based on User's Feedback



SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / tulsi

four rows will be returned displaying null as the last row

Is This Answer Correct ?    13 Yes 1 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / sdp

4 rows

Is This Answer Correct ?    5 Yes 2 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / gvmahesh

4 rows

1.vanilla
2.chocolate
3.strawberry
4.null

Is This Answer Correct ?    4 Yes 1 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / kapil

It would return 4 rows

because there is also a sum of ice_cream_sales for null also

so it would return 4 rows including null with order
dependimg on the value of sum function returned .

Is This Answer Correct ?    3 Yes 1 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / sree

3 rows

Is This Answer Correct ?    1 Yes 2 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / roopa

3rows'

Is This Answer Correct ?    2 Yes 5 No

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / 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

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the &..

Answer / guest

10 rows

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More SQL PLSQL Interview Questions

How to trace the errors in pl/sql block code?

5 Answers   TCS,

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

How many unique keys can a table have?

0 Answers  

Can u create a primary key with out unique index.

8 Answers  

How you will create Toad Function?

1 Answers  

How do I copy a table in sql?

0 Answers  

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

What is the difference between a query and a report?

0 Answers  

What are hotfixes and patches?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

what is oracle database ? : Sql dba

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories