Multiple choice technology databases

Sub-query cannot have following clause

  1. Order by

  2. Having

  3. Group by

  4. Where
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In standard SQL, a subquery cannot have an ORDER BY clause when used in contexts where a set operation is expected (like WHERE, HAVING, or as a derived table). The ORDER BY would only apply to the outer query. However, this is context-dependent - some modern SQL implementations allow ORDER BY in subqueries with LIMIT/OFFSET.

Keep practicing — related questions