Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between group by and order by?
- 2 Answers
- 14728 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 optimizer?
What are iseries servers?
What is the role of data manager in the db2 database?
How can deadlocks be resolved?
What is the syntax for FETCH in DB2 ?
How to retrieve rows from a db2 table in embedded sql?
What is the advantage in De-normalizing tables in DB2?
Mention the downsides of page level lock.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Why cursor is used in db2?
What are db2 objects?
What is cursor in dbms?
Explain the contention situations caused by locks?
What is the use of with ur in db2?
Where can you declare a cursor in a cobol-db2 program?
