Oracle - SQL - Table - List top n rows of a table in order
SELECT
*
FROM
(
SELECT
*
FROM
t
ORDER
BY
c
)
WHERE
ROWNUM
<=
n;