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

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

Answer Posted / sree

3 rows

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037


How to add new employee details in an employee_details table with the following details

1079


what is rdbms? : Sql dba

998


How does one load ebcdic data? : aql loader

1150


What is user defined functions?

954


What is cursor status?

1177


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2151


Is there a way to automate sql execution from the command-line, batch job or shell script?

954


What is cte?

963


Is it important to partition hard disk?

1005


What is crud diagram?

927


Does postgresql run on the cloud?

1128


What are the qualities of 2nf?

1023


What is faster join or subquery?

998


how is myisam table stored? : Sql dba

1036