Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ FAQs/ What are the differences between LIMIT 2, LIMIT 2,3 and LIMIT 2 OFFSET 3?
Updated on 2025-08-19 GMT+08:00
What are the differences between LIMIT 2, LIMIT 2,3 and LIMIT 2 OFFSET 3?
Answer: LIMIT and OFFSET are keywords used to limit the number of query results returned in the SELECT statement.
- LIMIT 2: Only the first two rows of data are returned.
- LIMIT 2,3: A total of three rows of data from the third row are returned.
- LIMIT 2 OFFSET 3: A total of two rows of data from the fourth row are returned.
Parent topic: FAQs
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
