(Choose two.)

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

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *