DB Wiki

Display the highest 5 salaries

SELECT id, description, salary
  FROM employees
ORDER BY salary DESC
FETCH FIRST 5 ROWS ONLY;

Display the 6th to the 10th highest salaries

SELECT id, description, salary
  FROM employees
ORDER BY salary DESC
OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY;

Can also use NEXT 20 PERCENT ROWS in place of NEXT 5 ROWS.
Can place WITH TIES at the end. This can mean you will get more than the number of rows you specified.