Title: (Optional) Describe the procedures for performing a top-n analysis.
Course: Database Design and Management (Oracle) (10052) > Section: Creating and Managing Views

Description should include the concept that a top-n analysis displays only the top or bottom n records (with n representing an integer) from ordered sets of data (e.g., top five earners, last 10 employees, 25 best-selling products), and use the following syntax:

SELECT [column_list], ROWNUM [ROWNUM_ALIAS]
FROM (SELECT [column_list] FROM table ORDER BY Top-N column)
WHERE ROWNUM <=n;