SQL - LIMIT And OFFSET

--To Retrieve A Portion Of Rows Returned By A Query, You Use The LIMIT And OFFSET Clauses.

SELECT column_list

FROM table1

ORDER BY column_list

LIMIT row_count OFFSET offset;

SELECT employee_id, first_name, last_name

FROM employees

ORDER BY first_name;

SELECT employee_id, first_name, last_name

FROM employees

ORDER BY first_name

LIMIT 5;

SELECT employee_id, first_name, last_name

FROM employees

ORDER BY first_name

LIMIT 5 OFFSET 3;