Top N analysis requires _____ and _____. (Choose two.)
A.
the use of rowid
B.
a GROUP BY clause
C.
an ORDER BY clause
D.
only an inline view
E.
an inline view and an outer query
Explanation:
The correct statement for Top-N Analysis
SELECT [coloumn_list], ROWNUM
FROM (SELECT [coloumn_list]
FROM table
ORDER BY Top-N_coloumn)
WHERE ROWNUM <= N;
Incorrect answer:
AROWID is not require
BGROUP BY clause is not require
DMust have inline view and outer query.