Multiple choice technology databases

The TOP option can appear in the

  1. FROM clause

  2. WHERE clause

  3. Correlated sub query

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The TOP option can appear in correlated subqueries. It allows limiting results from the subquery, which is then used by the outer query for comparison or filtering. TOP does not belong in FROM or WHERE clauses directly.

Keep practicing — related questions