Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between group by and order by?
- 2 Answers
- 14511 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil1405
Group By controls the presentation of rows , order by
controls the presentation of columns.
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / visakh viswanath
Difference between order by and group by having ?
suppose i have students table which has id number ,sname
varchar2(20),marks1number ,marks2 number,marks3 number,age
number.
i would like to illustrate what i understood
suppose i want to select students whose id > 2000 and age
>30
my query would be like this
select * from students where id >2000 and age >30 order by
age desc ;
or
else
select * from students group by age ,id having age >30 and
id >2000 ;
so both the queries would be same but in the first one i
use order by followed by my condition in where .
in second once i used group by which would group according
to the age or id and then having is same as where condition
in the above .
| Is This Answer Correct ? | 3 Yes | 7 No |
How does cobol compile db2 program?
How many Buffer pools are there in DB2 and what are they?
How does one remove entries from the SCT02 table?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is innodb buffer pool?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
how to unload different table data into different gdg files/ vsam files.
What does the CHECK Utility do ?
What is the purpose of the QUIESE Utility?
What is dclgen in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
COBOL 
