Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AWS AI GO KOTLIN SASS VUE GEN AI 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


W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2023 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.