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.