Multiple choice technology databases

Top N analysis requires _____ and ______?(Choose two)

  1. the use of rowed

  2. a GROUP BY clause

  3. an ORDER BY clause

  4. only an inline view

  5. an inline view and an outer query
Reveal answer Fill a bubble to check yourself
C,E Correct answer
Explanation

Top-N queries need sorted data (ORDER BY) and a way to limit results - typically using an inline view with ROWNUM (Oracle) or LIMIT/FETCH (other databases) plus an outer query. Inline views are standard; GROUP BY is for aggregation.

Keep practicing — related questions