Explanation:
If you want to rank the top three sales representatives who have sold the maximum number of products TOP-N query will be the best solution. TON-N queries use inline views and are handy for displaying a short list of table data, based on “greatest” or “least” criteria.
Incorrect Answers:
1: To complete this request you don’t need to use TOP-N query.
2: It is not necessary to use TOP-N query in this case.
3: To complete this request you don’t need to use TOP-N query.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 162-165
Chapter 4: Subqueries

---