PostgreSQL LIMIT
The LIMIT Clause
The LIMIT
clause is used to limit the maximum number of records to return.
Example
Return only the 20 first records from the customers table:
SELECT * FROM customers
LIMIT 20;
Run Example »
The OFFSET Clause
The OFFSET
clause 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 both
LIMIT and OFFSET.
Note: The first record is number
0, so when you specify
OFFSET 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 »
Exercise?What is this?
Test your skills by answering a few questions about the topics of this page
If the customers table has 100 records, how many records will be return with this SQL statement:SELECT * FROM customers LIMIT 10;
