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:
A:
ROWID is not require
B:
GROUP BY clause is not require
D:
Must have inline view and outer query.Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 11-23
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;
C.
an ORDER BY clause
E.
an inline view and an outer query