PostgreSQL Notes
PrevChapter 2. Basic queriesNext

Returning the next N results

You want the second (or fifteenth) page of your results.

Solution

Use the OFFSET keyword to modify your LIMIT ref.

Discussion

To get a second or subsequent "page" of results, add the OFFSET keyword to your query: 

SELECT * FROM companies ORDER BY co_id LIMIT 5 OFFSET 5;
PrevHomeNext
Returning the first N resultsUpReturning the last N results