R - The record type being returned by this querypublic interface SimpleSelectWhereStep<R extends Record> extends SimpleSelectOrderByStep<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 |
|---|---|
SimpleSelectConditionStep<R> |
where(Collection<Condition> conditions)
Add a
WHERE clause to the query |
SimpleSelectConditionStep<R> |
where(Condition... conditions)
Add a
WHERE clause to the query |
SimpleSelectConditionStep<R> |
where(String sql)
Add a
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SimpleSelectConditionStep<R> |
where(String sql,
Object... bindings)
Add a
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SimpleSelectConditionStep<R> |
where(String sql,
QueryPart... parts)
Add a
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. |
SimpleSelectConditionStep<R> |
whereExists(Select<?> select)
Add a
WHERE EXISTS clause to the query |
SimpleSelectConditionStep<R> |
whereNotExists(Select<?> select)
Add a
WHERE NOT EXISTS clause to the query |
orderBy, orderBy, orderBy, orderBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBylimit, limit, limit, limit, limit, limitforShare, 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 SimpleSelectConditionStep<R> where(Condition... conditions)
WHERE clause to the query@Support SimpleSelectConditionStep<R> where(Collection<Condition> conditions)
WHERE clause to the query@Support SimpleSelectConditionStep<R> where(String sql)
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String)@Support SimpleSelectConditionStep<R> where(String sql, Object... bindings)
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, Object...)@Support SimpleSelectConditionStep<R> where(String sql, QueryPart... parts)
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
@Support SimpleSelectConditionStep<R> whereExists(Select<?> select)
WHERE EXISTS clause to the query@Support SimpleSelectConditionStep<R> whereNotExists(Select<?> select)
WHERE NOT EXISTS clause to the queryCopyright © 2013. All Rights Reserved.