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

Subqueries in SQL cannot use ORDER BY clause because subqueries return a set of rows used by the outer query, and the outer query determines the final ordering. However, subqueries can use WHERE for row filtering and HAVING for group filtering. ORDER BY is only allowed in the outermost query or in subqueries that use TOP/LIMIT/FETCH FIRST clauses (not in this question's context).

Keep practicing — related questions