|The jOOQ User Manual : SQL building : QueryParts : SQL transformation : ROWNUM to LIMIT||previous : next|
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
ROWNUM to LIMIT
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Old Oracle SQL statements may use
ROWNUM filtering to paginate, as Oracle has introduced support for FETCH FIRST only in Oracle 12c.
-- Input SELECT * FROM t WHERE rownum = 1
-- Output SELECT * FROM t LIMIT 1
Settings settings = new Settings() .withTransformRownum(Transformation.WHEN_NEEDED);