What is the differnce between Order by and Group by



What is the differnce between Order by and Group by..

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

More Databases AllOther Interview Questions

What does currency type mean in database?

0 Answers   Amazon,


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  


What are the tools used for backup and ticketing?

0 Answers   Alcatel-Lucent,


in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session

1 Answers  


How many types of locks are present in a database?

0 Answers   Abacus,






How is image stored in database?

0 Answers  


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

0 Answers  


What is database server and how it works?

0 Answers  


what is rcp,if rcp disabled what happen?

0 Answers   Systel,


1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

0 Answers  


What does new grouping sets enables you to do?

0 Answers   ADITI,


i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,


Categories