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
How can you fetch common records from two tables?
Which query operators in sql is used for pattern matching?
What do you mean by stored procedures?
What is rownum in sql?
Do stored procedures prevent sql injection?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the different schemas objects that can be created using pl/sql?
What is difference between nchar and nvarchar?
What is pl sql variable?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How to fix oracle error ora-00942: table or view does not exist
Is record in pl sql?
what does myisamchk do? : Sql dba
How global cursor can be declare with dynamic trigger ?
How do you use collections in procedure to return the resultset?