LIMIT is followed by a number to indicate the maximum number of rows in the output results.  If no LIMIT statement is added, only 100 rows are output by default.
Note
Limit offset and lines syntaxes are not supported.

  Example:

*| select avg(latency) as avg_latency , methodgroupbymethodorderbyavg_latencydesclimit100