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 are different types of indexes?
What is the usage of sql functions?
How can you tell the difference between an index and a view?
what are the differences between char and nchar? : Sql dba
What is foreign key sql?
What are the types of triggers in sql?
In what condition is it good to disable a trigger?
Explain what is dbms?
What is the maximum database size for sql express?
What is %type in sql?
What is a primary key sql?
What are operators available in sql?
What is a procedure in pl sql?
how can we repair a mysql table? : Sql dba
What is the difference between delete, truncate and drop command?
