Interested to Buy Any Domain ? << Click Here >> for more details...
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 to process query result in pl/sql?
How to read xml file in oracle pl sql?
What are the parts of a sql statement?
What is the sql*loader? : aql loader
What is a sql*loader control file?
What is the difference between inner join and outer join?
Are stored procedures compiled?
What does plv msg allows you to do?
Can we change the table name in sql?
How do I remove sql plus from windows 10?
which types of join is used in sql widely? : Sql dba
What is a common use of group by in sql?
What are the sql aggregate functions?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
what is a foreign key ? : Sql dba
