Multiple choice

Top N analysis requires ____________ and ____________.

  1. the use of rowed, only an inline view

  2. a GROUP BY clause, only an inline view

  3. an ORDER BY clause, an inline view and an outer query

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

Top-N queries require sorting data and then limiting results, which needs ORDER BY for sorting, an inline view to perform the sorting, and an outer query to restrict the rows returned. Option A is missing the outer query. Option B incorrectly suggests GROUP BY and lacks the outer query. The standard pattern is SELECT * FROM (SELECT ... ORDER BY ...) WHERE ROWNUM <= N.

Keep practicing — related questions