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

3rows'

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various levels of constraints?

1123


What is the most restrictive isolation level? : Transact sql

1083


What does := mean in pl sql?

1042


What is the difference between function and procedure in pl/sql?

1082


what are ddl statements in mysql? : Sql dba

1199


Why triggers are used?

988


What is db journal file?

1064


What is a ddl command?

1085


Explain the components of sql?

1060


How to select random rows from a table?

1075


What is pivot table in sql?

1107


What is the difference between null value, zero, and blank space?

1203


Are views faster than queries?

992


What is a table in a database?

1045


how to get a list of columns in an existing table? : Sql dba

965