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 difference between stored procedure and trigger?
Why is sql better than hql?
What does an inner join do?
How do I add a primary key to a table?
What is dml and ddl?
How do you optimize a query?
What are the different types of joins in sql?
Can a trigger call a stored procedure?
What is the use of function "module procedure" in pl/sql?
Does view contain data?
What are the parts of a basic sql query?
What is trigger and types?
What are the types of optimization?
What is schema in sql example?
What is clustered index in sql?
