Top N analysis requires _ and _. (Choose two.)

The correct answer is C. an ORDER BY clause E. an inline view and an outer query. The correct statement for Top-N Analysis SELECT [coloumn_list], ROWNUM FROM (SELECT [coloumn_list] ORDER BY Top-N_coloumn) WHERE ROWNUM <= N;

Using Subqueries to Solve Queries

Question

Top N analysis requires _____ and _____. (Choose two.)

Options

Athe use of rowid
Ba GROUP BY clause
Can ORDER BY clause
Donly an inline view
Ean inline view and an outer query

How the community answered

(43 responses)

A
5% (2)
B
7% (3)
C
74% (32)
D
14% (6)

Explanation

The correct statement for Top-N Analysis SELECT [coloumn_list], ROWNUM FROM (SELECT [coloumn_list] ORDER BY Top-N_coloumn) WHERE ROWNUM <= N;

Topics

#Top-N analysis#inline view#ORDER BY#ROWNUM

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice