ROW_NUMBER() window function

ROW_NUMBER() OVER function can be used as a function to limit rows by specifying no of rows to view.

SELECT * FROM
( SELECT
ROW_NUMBER() OVER (ORDER BY sort_key ASC) AS row_number,
COLUMNS
FROM tablename
) A(name of select statement)
WHERE row_number <= 10

read more