Limit ClauseLimit Clause
JoSQL also supports a MySQL-style "LIMIT" clause that allows you to limit the records returned by the query. The general syntax is:
LIMIT ValueExpression [ , ValueExpression ]
The first value specifies the "start" row, the second (optional) value indicates the number of rows to return. If either function evaluates to a floating-point number then it is rounded to the nearest integer and that used instead. The rows are numbered from 1 upwards. A ValueExpression is an expression that will return a numeric result, for instance 10 + 20, in this way it is possible use bind variables and save values in the expression. If the "rows" value is larger than the results then start - end is returned.

For example:
FROM   java.io.File
LIMIT 10, 100
See Also