so far, the subqueries we saw do not depend on any other query , and it will execute the subquery just once. but when it comes to a correlated subquery it's going to be slightly different. for every ...

ORDER BY phrases cannot be used in subqueries (although ORDER BY phrases can still be used in outer queries that contain subqueries). Subqueries in SELECT or WHERE clauses that return more than one ...