This document introduces the usage and examples of the
LIMIT syntax is used to limit the number of rows in the output result.
CLS supports either of the following types of
offset S limit N
- In page turning read,
LIMITis only used to obtain the final result, not the intermediate result of the SQL statement.
LIMITsyntax cannot be used in subqueries. Example:
* | select sum(pv) from ( select count(1) as pv from log group by status )
* | select status, count(*) as pv group by status limit 10
* | select status, count(*) as pv group by status offset 2 limit 40
|Number of analysis results||Each analysis returns up to 10,000 results.||Default: 100; Maximum: 10,000|