The LIMIT syntax is used to limit the number of result rows returned by a SELECT statement. By default, only 100 rows of data are returned when performing query and analysis on logs. You can adjust the number of returned rows using the LIMIT syntax, with a supported range of 1 to 1,000,000. This article introduces the LIMIT syntax format and examples.

Syntax format

LIMIT syntax is as follows.

Return the first n rows of data from the calculation results.

LIMIT n

Return n rows of data from the calculation results, starting from row s+1; only data from row s+1 onward is read, and the total number of rows read is n.

OFFSET s LIMIT n

The parameters are described below:

Parameter

Description

Parameter	Description
n	Number of returned data rows. n has a default value of 100, with a valid range of 1 to 1,000,000.
s	Start reading from line s+1. The default value of s is 0, and its valid range is 0 to 999,999. That is, reading starts from line 1 by default, and you can start reading from line 1,000,000 at most. The sum of s and n should be less than or equal to 1,000,000.