1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

What is the differnce between Order by and Group by

Question Posted / guest


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 is the difference between a stored procedure and a query?

0 Answers   C DAC, CDAC,

Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,

How many types of normalization? What is the use of it?

0 Answers   Accenture,

Data structure used to implements a menu:

0 Answers   Verifone,

What is Object Oriented model?

0 Answers   Thomson Reuters,




hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  

How many types of locks are present in a database?

0 Answers   Abacus,

what is tkprof tool and how it is used???

0 Answers   Genpact,

Which is the best graph database?

0 Answers  

1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

1 Answers   Wipro,

What is replicaset?

0 Answers  

Explain storage manager?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories