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
Define concurrency control. : Transact sql
Is sql procedural language?
Is time a data type in sql?
What are the constraints available in sql?
What are three advantages to using sql?
Is not null in sql?
Why we use cross join?
How do you write a subquery?
How can I tell if sql is running?
What is the difference between microsoft sql and mysql?
what tools available for managing mysql server? : Sql dba
how to include character strings in sql statements? : Sql dba
How we can update the view?
How do I count records in sql?
what are numeric data types? : Sql dba
