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

10 rows

Is This Answer Correct ?    1 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you join a table to itself?

1033


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

951


How to display the records between two range in Oracle SQL Plus?

1101


How do I start pl sql?

899


What are triggers in sql?

974


How is data stored on a disk?

965


What are the different types of a subquery?

984


What are the two types of cursors in pl sql?

1004


Why stored procedure is faster than query?

951


What are different functions in sql?

899


How many databases can sql express handle?

943


Can you have a foreign key without a primary key?

901


What packages are available to pl/sql developers?

996


How to run sql statements through the web interface?

986


What is scalar function in sql?

979