When an SQL SELECT command has a subquery within it ____.
A) the subquery is executed first
B) the subquery is executed last
C) there is just one SELECT clause in the entire command, including the subquery
D) all predicates in the subquery's WHERE clause are passed back to the main query
E) all predicates in the main query's WHERE clause are passed down to the subquery

Question

Quizplus · Accepted Answer

When an SQL SELECT command has a subquery within it, the subquery is executed first before the outer query.

When an SQL SELECT Command Has a Subquery Within It