R
- The record type being returned by this querypublic interface SimpleSelectOffsetStep<R extends Record> extends SimpleSelectForUpdateStep<R>
Select
's DSL API when selecting specific
Record
types.
Example:
Refer to the manual for more details
create.selectFrom(T_AUTHOR)
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Modifier and Type | Method and Description |
---|---|
SimpleSelectForUpdateStep<R> |
offset(int offset)
Add an
OFFSET clause to the query
If there is no LIMIT .. |
SimpleSelectForUpdateStep<R> |
offset(Param<Integer> offset)
Add an
OFFSET clause to the query using a named parameter
If there is no LIMIT .. |
forShare, forUpdate
getQuery
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, fetchResultSet, getRecordType, getResult, keepStatement, maxRows, queryTimeout
cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable
internalAPI
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> offset(int offset)
OFFSET
clause to the query
If there is no LIMIT .. OFFSET
or TOP
clause in
your RDBMS, or if your RDBMS does not natively support offsets, this is
simulated with a ROW_NUMBER()
window function and nested
SELECT
statements.
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> offset(Param<Integer> offset)
OFFSET
clause to the query using a named parameter
If there is no LIMIT .. OFFSET
or TOP
clause in
your RDBMS, or if your RDBMS does not natively support offsets, this is
simulated with a ROW_NUMBER()
window function and nested
SELECT
statements.
Copyright © 2013. All Rights Reserved.