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

What is the differnce between Order by and Group by

Answer Posted / guest

Order by is to sort the output records based on some
columns and group by is to group the records and to apply
aggregate functions on the particular columns

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the disadvantages of views in a database?

1101


Data structure used to implements a menu:

1211


What is a Transformation?

1067


Why do we need distributed database?

1042


Explain data independence & its types.

1091


What is a driver in database?

1228


How to produce such kind of file?

1150


How much does it cost to build a database?

1071


On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

1034


Explain the various types of normalization.

1123


How does non-cluster index functions?

1178


I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1586


What are different types of joins used in?

1160


What are the concurrency problems a database faces?

1076


How to do performance tunning a database in DB2 V8.2 UDB in linux

2305