R - The record type being returned by this querypublic interface SimpleSelectLimitStep<R extends Record> extends SimpleSelectForUpdateStep<R>
Select's DSL API when selecting specific
Record types.
Example:
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 |
|---|---|
SimpleSelectOffsetStep<R> |
limit(int numberOfRows)
Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, this may be simulated with a ROW_NUMBER() window function
and nested SELECT statements. |
SimpleSelectForUpdateStep<R> |
limit(int offset,
int numberOfRows)
Add a
LIMIT clause to the query
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SimpleSelectForUpdateStep<R> |
limit(int offset,
Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SimpleSelectOffsetStep<R> |
limit(Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SimpleSelectForUpdateStep<R> |
limit(Param<Integer> offset,
int numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SimpleSelectForUpdateStep<R> |
limit(Param<Integer> offset,
Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
forShare, forUpdategetQuerybind, 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, queryTimeoutcancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutableinternalAPI@Support SimpleSelectOffsetStep<R> limit(int numberOfRows)
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, this may be simulated with a ROW_NUMBER() window function
and nested SELECT statements.
This is the same as calling limit(int, int) with offset = 0, or
calling .limit(numberOfRows).offset(0)
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectOffsetStep<R> limit(Param<Integer> numberOfRows)
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses!
If there is no LIMIT or TOP clause in your
RDBMS, or the LIMIT or TOP clause does not
support bind values, this may be simulated with a ROW_NUMBER()
window function and nested SELECT statements.
This is the same as calling limit(int, int) with offset = 0, or
calling .limit(numberOfRows).offset(0)
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> limit(int offset, int numberOfRows)
LIMIT clause to the query
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses!
If there is no LIMIT 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,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> limit(int offset, Param<Integer> numberOfRows)
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses!
If there is no LIMIT or TOP clause in your
RDBMS, or the LIMIT or TOP clause does not
support bind values, or if your RDBMS does not natively support offsets,
this may be simulated with a ROW_NUMBER() window function and
nested SELECT statements.
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> limit(Param<Integer> offset, int numberOfRows)
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses!
If there is no LIMIT or TOP clause in your
RDBMS, or the LIMIT or TOP clause does not
support bind values, or if your RDBMS does not natively support offsets,
this may be simulated with a ROW_NUMBER() window function and
nested SELECT statements.
@Support(value={CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) SimpleSelectForUpdateStep<R> limit(Param<Integer> offset, Param<Integer> numberOfRows)
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses!
If there is no LIMIT or TOP clause in your
RDBMS, or the LIMIT or TOP clause does not
support bind values, or if your RDBMS does not natively support offsets,
this may be simulated with a ROW_NUMBER() window function
and nested SELECT statements.
Copyright © 2013. All Rights Reserved.