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 coalesce in sql?
what are the differences between char and nchar? : Sql dba
What is cte?
What is a behavioral trigger?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
what is sp_pkeys? : Transact sql
Name the different types of indexes in sql and define them.
Can we join tables without foreign key?
What do you understand by pl/sql cursors?
What is the difference between left join and right join?
Does access use sql?
What is trigger types of trigger?
Can there be more than one function with a similar name in a pl/sql block?
What is the clause we need to add in function body to return variable?
How does rowid help in running a query faster?
