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

A correlated subquery references columns from the outer query. In this case, the subquery references "s1.Salesman_ID" from the outer query.

The Following SQL Statement Is an Example of a Correlated