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; Incorrect answer: A ROWID is not require B GROUP BY clause is not require D Must have inline view and outer query.

Displaying Data from Multiple Tables and Subqueries

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

(61 responses)

A
13% (8)
B
3% (2)
C
77% (47)
D
7% (4)

Explanation

The correct statement for Top-N Analysis SELECT [coloumn_list], ROWNUM FROM (SELECT [coloumn_list] ORDER BY Top-N_coloumn) WHERE ROWNUM <= N; Incorrect answer: A ROWID is not require B GROUP BY clause is not require D Must have inline view and outer query.

Topics

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice