Answer / sunil1405

Group By controls the presentation of rows , order by
controls the presentation of columns.

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 .

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is tablespace?

3 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

How is a typical DB2 batch program executed ?

1 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What is dbrm? When it will be created?

0 Answers  

---