Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

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 »

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Write the correct SQL statement to select first 10 records from the table customers.

 * FROM customers
;
        

Start the Exercise