EasyBasic SELECT

Get 2nd page of employees (OFFSET pagination)

The query

SQL

SELECT emp_id, first_name, last_name, salary
FROM employees
ORDER BY emp_id
LIMIT 10 OFFSET 10; -- Page 2 (10 per page)

Tested against PostgreSQL 16

Note

“OFFSET skips rows. Page N = OFFSET (N-1)*page_size. Beware: slow on large tables.