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.