LIMIT Syntax
Last updated: 2024-01-20 17:25:15
The
LIMIT syntax is used to limit the number of rows in the output result.Syntax Format
Read the first N rows:
limit N
Read N rows starting from row S:
offset S limit N
Syntax Example
Get the first 10 rows of results:
* | select status, count(*) as pv group by status limit 10
Get the results for rows 3 to 42 (40 rows in total):
* | select status, count(*) as pv group by status offset 2 limit 40
Restrictions
Metric | Restriction | Remarks |
Number of SQL results | Each SQL returns up to 10,000 results. | Default: 100; Maximum: 10,000 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback