JPQL: MySQL-like LIMIT-clause
hi
i was wondering if i could possibly limit a JPQL result list in the way that it only contains a specified number of rows starting at a certain offset.
for example, in MySQL i could simply use LIMIT like this:
SELECT * FROM example ORDER BY c1 LIMIT 20, 10
and it would return 10 rows starting at 20th row instead of the whole realtion.
any help will be appreciated