Answer Posted / bis
A query which uses values from the outer query is called as a correlated sub query. The subquery is executed once and uses the results for all the evaluations in the outer query.
Here, the sub query references the employee_id in outer query. The value of the employee_id changes by row of the outer query, so the database must rerun the subquery for each row comparison. The outer query knows nothing about the inner query except its results.
select employee_id, appraisal_id, appraisal_amount From employee
where
appraisal_amount < (select max(appraisal_amount)
from employee e
where employee_id = e. employee_id);
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a unique constraint?
What jobs use sql?
What is server name sql?
What is sql and db2?
What is difference between sql and mysql?
What is trigger in flip flop?
What is the need of a partition key?
What is before and after trigger?
How do I debug a stored procedure?
What does the sign mean in sql?
What is numeric function sql?
Does mysql support pl sql?
What does (+) mean in sql joins?
How to install oracle sql developer?
How do I access sql anywhere database?