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

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

0 Answers  


Difference between sql and mysql?

0 Answers  


What are different types of resources?

0 Answers  


Its possible to use auto increment in oracle or not? If no means why?

1 Answers  


How to do Data size testing? Who does this testing (Developer or tester)?

0 Answers  






What is ole db in ssis?

0 Answers  


can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,


Explain alternate key?

0 Answers  


issues involved in modeling and building data werahouses

0 Answers  


What is replicaset?

0 Answers  


What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,


Categories