Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between group by and order by?
- 2 Answers
- 14633 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 the responsibility of the construction superintendent
What is a db2 collection?
Explain db2.
What is the purpose of using commit?
Is schema the same as database?
Which isolation level provides highest data integrity?
Can you tell me how can you find out the # of rows updated after an update statement?
What is query_cache_limit?
What is role in db2?
What is declare cursor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Why db2 is called db2?
What is db2? Explain.
What is the physical storage length of the data types date, time, and timestamp?
What are concurrency issues?
