The LIMIT feature has been added to the standard EJBQL query language. This feature enables you to retrieve just a portion of the results generated by the rest of a query.
The syntax of the LIMIT clause is:
limit_clause ::= LIMIT limit_expression (, limit_expression )? limit_expression ::= integer_literal | input_parameter |
The first limit_expression corresponds to the start_at range and the second one to the size range.
The limit_clause is the last clause of the query:
ejbql ::= select_clause from_clause [where_clause] [orderby_clause] [limit_clause] |
Example:
SELECT OBJECT(c) FROM jt2_Customer AS c ORDER BY c.id LIMIT ?1, 20 |
![]() | Note |
---|---|
This feature is currently not implemented on all the database types supported by JORM/MEDOR. |