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 .

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

What is runstats utility in db2?

0 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

Update command

1 Answers  

---

What is a clustered index?

1 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Who uses db2?

0 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

what is different three logs in DB2?

1 Answers   Syntel,

---