Interested to Buy Any Domain ? << Click Here >> for more details...
Could anyone clearly explain the diference between sub
query and correlated sub query?
- 3 Answers
- 6108 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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...............
| Is This Answer Correct ? | 2 Yes | 0 No |
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...............
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / praveen
if we want to select 100th hig no.
in sub-query we will write 100 conditions.
to avoid this we go for correlated sub-query
| Is This Answer Correct ? | 0 Yes | 0 No |
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is the use of db2?
How do I change the column size in db2?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is the physical storage length of the data types date, time, and timestamp?
can any one expalin check point with an example?
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
What are the three types of page locks that can be held?
What are the levels of isolation available with DB2V4
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?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
COBOL 
