The LIMIT clause restricts the number of output events.
Syntax:
limit numberOfRows [offset offsetNumber]
Only the number of events specified at numberOfRows are output.
By specifying an offsetNumber, the number of rows of events that are output starts from a specified position rather than from the start of the results.
As with SQL, the syntax below can also be used.
Syntax:
limit offsetNumber [,numberOfRows]