The following SQL statement is an example of a correlated subquery.
select first_name, last_name, total_sales
from salesman s1
where total_sales all
(select total_sales from salesman s2
where s1.salesman_id != s2.salesman_id);

Question

The following SQL statement is an example of a correlated subquery.
select first_name, last_name, total_sales
from salesman s1
where total_sales > all
(select total_sales from salesman s2
where s1.salesman_id != s2.salesman_id);

Quizplus · Accepted Answer

The subquery in the WHERE clause is correlated with the outer query as it refers to a column (salesman_id) from the outer table (s1) in the WHERE condition. This type of subquery is called a correlated subquery.

The Following SQL Statement Is an Example of a Correlated