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 the set operators in sql?
What is sql select statement?
Enlist the data types that can be used in pl/sql?
What are types of indexes in sql?
Explain the purpose of %type and %rowtype data types with the example?
Why we use cross join?
How do I create a memory optimized filegroup?
When should I use nosql database?
what is innodb? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Show the two pl/sql cursor exceptions.
Which join is like inner join?
How to select 10 records from a table?
What is the function that is used to transfer a pl/sql table log to a database table?
What is a join?
