Help Center/
GaussDB/
Developer Guide(Distributed_8.x)/
FAQs/
What are the differences between LIMIT 2, LIMIT 2,3 and LIMIT 2 OFFSET 3?
Updated on 2024-06-03 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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot