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 .

How does coalesce work?

962

---

What is db2 stogroup?

1095

---

What is reorg and runstats in db2?

1147

---

What is the maximum No of rows per page?

1013

---

How to rename a table in DB2 ?

1032

---

How do I copy a table in db2?

953

---

What do you mean by storage group (stogroup)?

984

---

What are foreign keys in db2?

1037

---

Mention some fields that are a part of sqlca.

972

---

Is db2 a mainframe?

970

---

What are the 2 sqlcodes that are returned?

1131

---

What is the difference between spufi and qmf?

1053

---

What is the advantage in De-normalizing tables in DB2?

1117

---

What is a collection in db2?

985

---

What is sqlca’s maximum length?

1104

---