Top
Interstage Big DataComplex Event Processing Server V1.1.0 Developer's Reference
FUJITSU Software

1.2.8 LIMIT Clause

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]