Where Clause Result Of Subquery. The right answer is. In the subqueries presented so far SQL evaluates the subquery and uses the result as part of the WHERE clause of the outer-level SELECT.
The outer query is correlated to the inner query by SalesPersonID. By default MySQL doesnt allow us to add a limit clause in our subqueries when using specific clauses like WHERE IN. After the subquery returns results the outer query makes use of them.
A subquery is a SELECT statement within another statement.
The right answer is. A subquery must be placed on the right side of the comparison operator. In the subqueries presented so far SQL evaluates the subquery and uses the result as part of the WHERE clause of the outer-level SELECT. Subqueries cannot manipulate their results internally therefore ORDER BY clause cannot be added into a subquery.