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
What company owns postgresql?
Explain the types of joins in sql?
What does a pl/sql package consist of?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
what is the use of set statement in tsql? : Transact sql
What is function and procedure?
What are the subsets of sql?
What are different types of queries in sql?
How can I delete duplicate rows?
What is difference between hql and sql?
What is the difference between an inner join and an outer join?
How do you declare a user-defined exception?
What is procedure in pl sql?
What are the different types of tables in sql?
What are analytic functions in sql?
