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 are aggregate and scalar functions?
What is bitemporal narrowing?
What is int identity in sql?
How do I install sql?
What is difference between cursor and trigger?
What is difference between stored procedures and application procedures?
Can two tables have same primary key?
Why indexing is needed?
How many triggers can be applied to a table?
What are instead of triggers?
is it possible to pass an object or table to a procedure as an argument?
What is the difference between inner join and natural join?
Explain table and field in sql?
What is memory optimized?
Difference between global and parameter variables?
