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 is the best free sql database?
how to include character strings in sql statements? : Sql dba
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Are stored procedures faster than queries?
What is varray in pl sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is the difference among union, minus and intersect?
Why do we use view in sql?
What is sap sql anywhere?
Is big data nosql?
Is sqlexception checked or unchecked?
Name the operator which is used in the query for pattern matching?
Why do we use sqlite?
What is synonyms?
what are tables and fields? : Sql dba
