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
- 6120 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 |
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
How to solve S0C7 abend with out using DISPlay in 10 mins?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What are the various locks available?
Are views updatable ?
What is pagespace?
How are write I/Os from the buffer pool executed?
What is the cobol picture clause of the db2 data types date, time, timestamp?
pls tell me abt the normalization five types....
How would the varchar column remarks defined?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
COBOL 
