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
- 5991 Views
- I also Faced
- E-Mail Answers
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...............
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of db2 optimizer?
What is view db2?
Can you use max on a char column?
How to get the ddl of a table in db2?
What is a db2 tablespace?
What is a db2 collection?
Give a brief description of db2 isolation levels?
On which levels locks can be applied?
What do you mean by cursor?
What is universal database?
How do you select a row using indexes in db2?
Define data page.
What are the contents of a dclmgen?
How to find primary key of a table in db2?
How can record locking be achieved in those DB2 versions which do not support it?
