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 .

Is schema the same as database?

0 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

How does db2 sample database connect?

0 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What is a lock?

1 Answers  

---

cobol-db2 runjcl please?

2 Answers   DELL,

---

What is a bind in db2?

0 Answers  

---

What are db2 objects?

0 Answers  

---