What is the difference between group by and order by?
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 a collection in db2?
What is alias in db2?
How do I change the column size in db2?
What is load replace in db2?
What is difference between rollback and commit?
What is phantom read in db2?
How do I add a column to an existing table in db2?
Explain in detail about buffer manager and its functionalities?
What is runstats and reorg in db2?
What is an instance database?
How can deadlocks be resolved?
Is the primary key a clustered index?
What are foreign keys in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the use of db2?