PostgreSQL LIMIT
The LIMIT Clause
TheLIMITclause is used to limit the maximum number of records to return.
Example
Return only the 20 first records from thecustomers table:
SELECT * FROM customers
LIMIT 20;
Run Example »LIMIT 20;
The OFFSET Clause
TheOFFSETclause is used to specify where to start selecting the records to return.
If you want to return 20 records, but start at number 40, you can use bothLIMIT andOFFSET.
Note: The first record is number0, so when you specifyOFFSET 40 it means starting at record number 41.
Example
Return 20 records, starting from the 41th record:
SELECT * FROM customers
LIMIT 20 OFFSET 40;
Run Example »LIMIT 20 OFFSET 40;
