Answer Posted / raj
Correlated sub query is evaluated once per row processed by the parent statement.
Example:which employee earn salary greater than avg salary of their department.
Query: select emp_no,emp_name,job,sal,dept_no from emp a where sal>(select avg(sal) from emp where dept_no=a.dept_no)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why is normalization important?
What is the purpose of a sql?
What are the advantages of sql? Explain
What is the difference between drop and truncate commands?
what is sp_pkeys? : Transact sql
Is and as keyword in pl sql?
Which sorts rows in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
Explain the purpose of %type and %rowtype data types?
What is break?
Explain commit, rollback and savepoint.
How do I start sql profiler?
what is 'mysqladmin' in mysql? : Sql dba
What is offset and limit in sql?
how to select first 5 records from a table? : Sql dba