By default, Log Service returns 100 rows of data in the query and analysis results. You can use a LIMIT clause to specify the number of rows that can be returned.

Syntax

Log Service supports the following types of LIMIT clauses:

  • The following LIMIT clause returns the first x rows of data in the query and analysis results: 
    LIMIT x
  • The following LIMIT clause returns x rows of data starting from the y row in the query and analysis results: 
    LIMIT y, x
Notice
  • The LIMIT clause is used to obtain final results rather than SQL intermediate results.
  • You cannot use LIMIT clauses in subqueries. For example, the following statement is invalid: * | select count(1) from ( select distinct(url) from limit 0,1000).

Parameters

Parameter Description
x The number of rows that can be returned.
  • If you use LIMIT x, the valid values of x are [0,1000000].
  • If you use LIMIT y, x, the valid values of x are [0,10000].
y The offset. Valid values: [0,1000000].
Notice The sum of x and y cannot exceed 1,000,000.

Examples

  • Return the first 200 rows of data in the query and analysis results.
    • Query statement
      * | SELECT  request_time LIMIT 200
    • Query and analysis resultslimit
  • Return 1,000 rows of data with an offset of 100 in the query and analysis results.
    • Query statement
      * | SELECT  request_time LIMIT 100,1000
    • Query and analysis resultslimit
  • Return the top three request URIs with the longest request durations.
    • Query statement
      * |
SELECT
  request_uri AS top_3,
  request_time
ORDER BY
  request_time DESC
LIMIT
  3
    • Query and analysis resultslimit