Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bindhu
Correlated subquery are used for row-by-row prcessing.Each
subquery is executed once for every row of the outer
query.It is one way of reading every row in a table and
camparing the values in each row againt the realted data.
Eg: select ename,sal,deptno from emp outer where sal >
(select avg(sal) from emp where deptno=outer.deptno);
Each time a row from the outer query is processed,the inner
query is evaluated.
| Is This Answer Correct ? | 103 Yes | 17 No |
Post New Answer View All Answers
What is Histogram?
What is the difference between partitioning and sharding?
What are variables in pl sql?
Can a foreign key have a different name?
What is sql indexing?
How many commands are there in sql?
What is the purpose of primary key?
What is data definition language?
Where can I learn sql for free?
What does subquery mean in sql?
What are tuples in sql?
What are the advantages of normalization?
What is an ndf file?
Do we need to rebuild index after truncate?
How do I upgrade sql?
