LIMIT ValueExpression [ , ValueExpression ]
For example:
SELECT * FROM java.io.File LIMIT 10, 100
Limit ClauseJoSQL also supports a MySQL-style "LIMIT" clause that allows you to limit the records returned by the query. The general syntax is:
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:
For example:
See Also
© Gary Bentley 2004-2007. All Rights Reserved.