Answer Posted / sriram

Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.

Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.

For example

Correlated Subquery:

select e1.empname e1.basicsal e1.deptno from emp e1 where
e1.basicsal (select max(basicsal) from emp e2 where
e2.deptno e1.deptno)

Nested Subquery:

select empname basicsal deptno from emp where (deptno
basicsal) in (select deptno max(basicsal) from emp group by
deptno)



Please let me know if I am wrong...............

What is the use of reorg in db2?

1024

---

List out the data types available.

1081

---

How do I add a column to an existing table in db2?

977

---

What do you mean by rollback?

932

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4214

---

What is the use of runstats in db2?

1022

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1086

---

i want to maintain uniqueness on pdf without make lf??????????

2098

---

Explain packages.

1055

---

How do you select a row using indexes in db2?

1073

---

What are the uses of db2 optimizer?

1223

---

How do I import a csv file into db2?

937

---

What is multi row fetch in db2?

986

---

What is cursor with hold option in db2?

1010

---

What is cursor in dbms?

1005

---