Top-n query pattern

SELECT ROWNUM, [list_of_column_names]
FROM (
SELECT [list_of_column_names_1]
FROM table_name
ORDER BY name_col_for_Top_n [DESC]
) WHERE ROWNUM <= N;