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 is a null value?

1187


What is the difference between partitioning and sharding?

1049


What are the types of sql commands?

1154


What are the three forms of normalization?

1092


What is a dirty read sql?

1241


what are the different tables present in mysql? : Sql dba

1036


What is a primary key sql?

1093


How can I change database name in sql?

1156


Can I learn sql in a week?

1118


What is clause?

1225


In a distributed database system, can we execute two queries simultaneously?

1152


What are the basic techniques of indexing?

1110


When you have to use a default "rollback to" savepoint of plvlog?

1249


Where can I learn sql for free?

1040


What does seeding a database mean?

1014