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

Is database a hardware or software?

0 Answers  


What is the relationship that exists inside in E-R diagram?

0 Answers   CGI,


What is database collection?

0 Answers  


how can you perform lookup range in lookup stage expalin in detail?

0 Answers   IBM,


Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key

1 Answers   Ignou,






what is the full procedure for using store procedure in informatica7.1?

0 Answers  


Explain entity type?

0 Answers  


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

8 Answers   CybAge, Wipro,


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

0 Answers   3i Infotech,


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

0 Answers   IBM,


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

0 Answers   Abacus,


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  


Categories