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 advantages of stored procedure?

989


Why we use stored procedure instead of query?

982


What are the types of triggers in sql?

1067


What is sql and how does it work?

1150


Is sqlite free?

950


How would you reference column values before and after you have inserted and deleted triggers?

1049


Does pdo prevent sql injection?

920


what is the use of friend function? : Sql dba

1009


Define concurrency control. : Transact sql

1153


How do I delete a trigger?

946


How do I view an execution plan in sql?

967


How many triggers can be applied on a table?

923


What are the key differences between SQL and PL SQL?

1198


what's the difference between a primary key and a unique key? : Sql dba

1031


Does varchar need length?

979