Multiple choice technology databases

Sub query cannot have which clause defined for it

  1. where

  2. having

  3. order by

  4. none of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Standard SQL subqueries cannot contain an ORDER BY clause because a subquery defines an unordered set of rows. Clauses like WHERE and HAVING are perfectly valid inside subqueries.