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 .

What is an intent lock?

3 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is the difference between plan and package in db2?

0 Answers  

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

What is DCLGEN?

2 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

How to select the duplicate rows from a table?

4 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---