目录
- PostgreSQL Tutorial
- Database
-
PostgreSQL Syntax
- PostgreSQL Operators
- PostgreSQL SELECT
- PostgreSQL
- PostgreSQL WHERE
- PostgreSQL ORDER BY
- PostgreSQL LIMIT
- PostgreSQL MIN and MAX
- PostgreSQL COUNT
- PostgreSQL SUM
- PostgreSQL AVG
- PostgreSQL LIKE
- PostgreSQL IN
- PostgreSQL BETWEEN
- PostgreSQL AS
- PostgreSQL Joins
- PostgreSQL INNER JOIN
- PostgreSQL LEFT JOIN
- PostgreSQL RIGHT JOIN
- PostgreSQL FULL JOIN
- PostgreSQL CROSS JOIN
- PostgreSQL UNION
- PostgreSQL GROUP BY
- PostgreSQL HAVING
- PostgreSQL EXISTS
- PostgreSQL ANY
- PostgreSQL ALL
- PostgreSQL CASE
- Exercises
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
截取页面反馈部分，让我们更快修复内容！也可以直接跳过填写反馈内容!