All Superinterfaces:: Attachable, AttachableQueryPart, AutoCloseable, ConditionProvider, FieldLike, Fields, Flow.Publisher<R>, Iterable<R>, Publisher<R>, org.reactivestreams.Publisher<R>, Query, QueryPart, ResultQuery<R>, Select<R>, Serializable, Statement, TableLike<R>

public interface SelectQuery<R extends Record> extends Select<R>, ConditionProvider

A SELECT statement (model API).

This type is the model API representation of a Select statement, which can be mutated after creation. The advantage of this API compared to the DSL API is a more simple approach to writing dynamic SQL.

Instances can be created using DSLContext.selectQuery() and overloads.

Author:: Lukas Eder

Method Summary

Modifier and Type

Method

Description

void

addConditions(Collection<? extends Condition> conditions)

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

addConditions(Condition condition)

Adds a new condition to the query, connecting them to existing conditions with Operator.AND.

void

addConditions(Condition... conditions)

Adds new conditions to the query, connecting them to existing conditions with Operator.AND.

void

addConditions(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

addConditions(Operator operator, Condition condition)

Adds a new condition to the query, connecting them to existing conditions with the provided operator.

void

addConditions(Operator operator, Condition... conditions)

Adds new conditions to the query, connecting them to existing conditions with the provided operator.

void

addConnectBy(Condition condition)

Add an Oracle-specific CONNECT BY clause to the query.

void

addConnectByNoCycle(Condition condition)

Add an Oracle-specific CONNECT BY NOCYCLE clause to the query.

void

addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)

Add a PostgreSQL-specific DISTINCT ON (fields…) clause.

void

addDistinctOn(SelectFieldOrAsterisk... fields)

Add a PostgreSQL-specific DISTINCT ON (fields…) clause.

void

addFrom(Collection<? extends TableLike<?>> from)

Add tables to the table product.

void

addFrom(TableLike<?> from)

Add tables to the table product.

void

addFrom(TableLike<?>... from)

Add tables to the table product.

void

addGroupBy(Collection<? extends GroupField> fields)

Adds grouping fields.

void

addGroupBy(GroupField... fields)

Adds grouping fields.

void

addHaving(Collection<? extends Condition> conditions)

Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.

void

addHaving(Condition condition)

Adds a new condition to the having clause of the query, connecting it with each other with Operator.AND.

void

addHaving(Condition... conditions)

Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.

void

addHaving(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the having clause of query, connecting them with each other with operator.

void

addHaving(Operator operator, Condition condition)

Adds a new condition to the having clause of query, connecting it with each other with operator.

void

addHaving(Operator operator, Condition... conditions)

Adds new conditions to the having clause of query, connecting them with each other with operator.

void

addHint(String hint)

Add an Oracle-style hint to the select clause.

void

addJoin(TableLike<?> table, Condition condition)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

addJoin(TableLike<?> table, Condition... conditions)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

addJoin(TableLike<?> table, JoinType type, Condition condition)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

addJoin(TableLike<?> table, JoinType type, Condition... conditions)

Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.

void

addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)

Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.

void

addJoinOnKey(TableLike<?> table, JoinType type)

Joins the existing table product to a new table using a foreign key.

void

addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)

Joins the existing table product to a new table using a foreign key.

void

addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)

Joins the existing table product to a new table using a foreign key.

void

addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)

Joins the existing table product to a new table with a USING clause.

void

addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)

Joins the existing table product to a new table with a USING clause.

void

addLimit(int numberOfRows)

Limit the results of this select.

void

addLimit(int offset, int numberOfRows)

Limit the results of this select.

void

addLimit(int offset, Param<Integer> numberOfRows)

Limit the results of this select using named parameters.

void

addLimit(Number numberOfRows)

Limit the results of this select.

void

addLimit(Number offset, Number numberOfRows)

Limit the results of this select.

void

addLimit(Number offset, Param<? extends Number> numberOfRows)

Limit the results of this select using named parameters.

void

addLimit(Param<? extends Number> numberOfRows)

Limit the results of this select using named parameters.

void

addLimit(Param<? extends Number> offset, Number numberOfRows)

Limit the results of this select.

void

addLimit(Param<? extends Number> offset, Param<? extends Number> numberOfRows)

Limit the results of this select using named parameters.

void

addLimit(Param<Integer> offset, int numberOfRows)

Limit the results of this select.

void

addOffset(int offset)

Add a 0-based OFFSET clause to the query.

void

addOffset(Number offset)

Add a 0-based OFFSET clause to the query.

void

addOffset(Param<? extends Number> offset)

Add a 0-based OFFSET clause to the query using a named parameter.

void

addOption(String option)

Add a SQL Server-style query hint to the select clause.

void

addOrderBy(int... fieldIndexes)

Adds ordering fields.

void

addOrderBy(Collection<? extends OrderField<?>> fields)

Adds ordering fields.

void

addOrderBy(OrderField<?>... fields)

Adds ordering fields.

void

addQualify(Collection<? extends Condition> conditions)

Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.

void

addQualify(Condition condition)

Adds a new condition to the qualify clause of the query, connecting it with each other with Operator.AND.

void

addQualify(Condition... conditions)

Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.

void

addQualify(Operator operator, Collection<? extends Condition> conditions)

Adds new conditions to the qualify clause of query, connecting them with each other with operator.

void

addQualify(Operator operator, Condition condition)

Adds a new condition to the qualify clause of query, connecting it with each other with operator.

void

addQualify(Operator operator, Condition... conditions)

Adds new conditions to the qualify clause of query, connecting them with each other with operator.

void

addSeekAfter(Collection<? extends Field<?>> fields)

Adds seeking fields.

void

addSeekAfter(Field<?>... fields)

Adds seeking fields.

void

addSeekBefore(Collection<? extends Field<?>> fields)

Deprecated.
- [#7461] - SEEK BEFORE is not implemented correctly

void

addSeekBefore(Field<?>... fields)

Deprecated.
- [#7461] - SEEK BEFORE is not implemented correctly

void

addSelect(Collection<? extends SelectFieldOrAsterisk> fields)

Add a list of select fields.

void

addSelect(SelectFieldOrAsterisk... fields)

Add a list of select fields.

void

addWindow(Collection<? extends WindowDefinition> definitions)

Adds new window definitions to the window clause of the query.

void

addWindow(WindowDefinition... definitions)

Adds new window definitions to the window clause of the query.

void

setConnectByStartWith(Condition condition)

Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.

void

setDistinct(boolean distinct)

Add "distinct" keyword to the select clause.

void

setForJSONAuto(boolean forJSONAuto)

Add a FOR JSON AUTO clause to the end of the query.

void

setForJSONB(boolean forJSONB)

Whether the FOR JSON query should produce JSONB instead of JSON.

void

setForJSONIncludeNullValues(boolean forJSONIncludeNullValues)

Add a FOR JSON ROOT clause to the end of the query.

void

setForJSONPath(boolean forJSONPath)

Add a FOR JSON PATH clause to the end of the query.

void

setForJSONRoot(boolean forJSONRoot)

Add a FOR JSON ROOT clause to the end of the query.

void

setForJSONRoot(boolean forJSONRoot, String rootName)

Add a FOR JSON ROOT clause to the end of the query.

void

setForJSONWithoutArrayWrapper(boolean forJSONWithoutArrayWrapper)

Add a FOR JSON ROOT clause to the end of the query.

void

setForKeyShare(boolean forKeyShare)

Sets the "FOR KEY SHARE" lock mode onto the query.

void

setForLockModeNoWait()

Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause.

void

setForLockModeOf(Collection<? extends Field<?>> fields)

Some RDBMS allow for specifying the fields that should be locked by the FOR <lock_mode> clause, instead of the full row.

void

setForLockModeOf(Field<?>... fields)

Some RDBMS allow for specifying the fields that should be locked by the FOR <lock_mode> clause, instead of the full row.

void

setForLockModeOf(Table<?>... tables)

Some RDBMS allow for specifying the tables that should be locked by the FOR <lock_mode> clause, instead of the full row.

void

setForLockModeSkipLocked()

Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause.

void

setForLockModeWait(int seconds)

Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause.

void

setForNoKeyUpdate(boolean forNoKeyUpdate)

Sets the "FOR NO KEY UPDATE" lock mode onto the query.

void

setForShare(boolean forShare)

Sets the "FOR SHARE" lock mode onto the query.

void

setForUpdate(boolean forUpdate)

Sets the "FOR UPDATE" lock mode onto the query.

void

setForUpdateNoWait()

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeNoWait()

void

setForUpdateOf(Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeOf(Collection)

void

setForUpdateOf(Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeOf(Field...)

void

setForUpdateOf(Table<?>... tables)

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeOf(Table...)

void

setForUpdateSkipLocked()

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeSkipLocked()

void

setForUpdateWait(int seconds)

Deprecated, for removal: This API element is subject to removal in a future version.
[#5218] - 3.14.0 - Use setForLockModeWait(int)

void

setForXMLAuto(boolean forXMLAuto)

Add a FOR XML AUTO clause to the end of the query.

void

setForXMLElements(boolean forXMLElements)

Add a FOR XML ELEMENTS clause to the end of the query.

void

setForXMLElementsAbsent(boolean forXMLElementsAbsent)

Add a FOR XML ELEMENTS ABSENT clause to the end of the query.

void

setForXMLElementsXsinil(boolean forXMLElementsXsinil)

Add a FOR XML ELEMENTS XSINIL clause to the end of the query.

void

setForXMLPath(boolean forXMLPath)

Add a FOR XML PATH clause to the end of the query.

void

setForXMLPath(boolean forXMLPath, String elementName)

Add a FOR XML PATH clause to the end of the query.

void

setForXMLRaw(boolean forXMLRaw)

Add a FOR XML RAW clause to the end of the query.

void

setForXMLRaw(boolean forXMLRaw, String elementName)

Add a FOR XML RAW clause to the end of the query.

void

setForXMLRoot(boolean forXMLRoot)

Add a FOR XML ROOT clause to the end of the query.

void

setForXMLRoot(boolean forXMLRoot, String rootName)

Add a FOR XML ROOT clause to the end of the query.

void

setForXMLType(boolean forXMLRoot)

Add a FOR XML TYPE clause to the end of the query.

void

setGroupByDistinct(boolean groupByDistinct)

Specifies the GROUP BY DISTINCT clause.

void

setInto(Collection<? extends Variable<?>> variables)

Add a PL/SQL style INTO clause to the SELECT statement to assign the projection of a single row SELECT statement to local variables in a procedural context.

void

setInto(Table<?> table)

Add a T-SQL style INTO clause to the SELECT statement to create a new table from a SELECT statement.

void

setLimitPercent(boolean percent)

Add the PERCENT clause to a LIMIT clause.

void

setOrderBySiblings(boolean orderBySiblings)

Indicate whether the SIBLINGS keyword should be used in an ORDER BY clause to form an ORDER SIBLINGS BY clause.

void

setWithCheckOption()

Add a WITH CHECK OPTION clause to the end of the subquery.

void

setWithReadOnly()

Add a WITH READ ONLY clause to the end of the subquery.

void

setWithTies(boolean withTies)

Add the WITH TIES clause to a LIMIT clause.

Methods inherited from interface org.jooq.Attachable
attach, configuration, detach

Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL

Methods inherited from interface org.jooq.FieldLike
asField, asField, asField

Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types

Methods inherited from interface java.lang.Iterable
forEach

Methods inherited from interface org.jooq.Publisher
subscribe

Methods inherited from interface org.reactivestreams.Publisher
subscribe

Methods inherited from interface org.jooq.Query
cancel, close, execute, executeAsync, executeAsync, isExecutable

Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Methods inherited from interface org.jooq.ResultQuery
bind, bind, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, collect, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAnyArray, fetchAnyInto, fetchAnyInto, fetchAnyMap, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchAsync, fetchAsync, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneInto, fetchOneInto, fetchOneMap, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptionalArray, fetchOptionalInto, fetchOptionalInto, fetchOptionalMap, fetchResultSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingleArray, fetchSingleInto, fetchSingleInto, fetchSingleMap, fetchSize, fetchStream, fetchStreamInto, fetchStreamInto, getRecordType, getResult, intern, intern, intern, intern, iterator, keepStatement, maxRows, poolable, queryTimeout, resultSetConcurrency, resultSetHoldability, resultSetType, spliterator, stream

Methods inherited from interface org.jooq.Select
$connectBy, $connectBy, $connectByNoCycle, $connectByNoCycle, $connectByStartWith, $connectByStartWith, $distinct, $distinct, $from, $from, $groupBy, $groupByDistinct, $groupByDistinct, $having, $having, $orderBy, $qualify, $qualify, $select, $select, $where, $where, $window, $with, except, exceptAll, getSelect, intersect, intersectAll, union, unionAll

Methods inherited from interface org.jooq.TableLike
asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable

Method Details
- addSelect
  
  @Support void addSelect(SelectFieldOrAsterisk... fields)
  
  Add a list of select fields.
  
  Parameters:
  
  fields -
- addSelect
  
  @Support void addSelect(Collection<? extends SelectFieldOrAsterisk> fields)
  
  Add a list of select fields.
  
  Parameters:
  
  fields -
- setDistinct
  
  @Support void setDistinct(boolean distinct)
  
  Add "distinct" keyword to the select clause.
- addDistinctOn
  
  @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addDistinctOn(SelectFieldOrAsterisk... fields)
  
  Add a PostgreSQL-specific DISTINCT ON (fields…) clause.
  This also sets the distinct flag to true
- addDistinctOn
  
  @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields)
  
  Add a PostgreSQL-specific DISTINCT ON (fields…) clause.
  This also sets the distinct flag to true
- setInto
  
  @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,TERADATA,VERTICA,YUGABYTEDB}) void setInto(Table<?> table)
  
  Add a T-SQL style INTO clause to the SELECT statement to create a new table from a SELECT statement.
- setInto
  
  @Pro @Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB}) void setInto(Collection<? extends Variable<?>> variables)
  
  Add a PL/SQL style INTO clause to the SELECT statement to assign the projection of a single row SELECT statement to local variables in a procedural context.
- addFrom
  
  @Support void addFrom(TableLike<?> from)
  
  Add tables to the table product.
  
  Parameters:
  
  from - The added tables
- addFrom
  
  @Support void addFrom(TableLike<?>... from)
  
  Add tables to the table product.
  
  Parameters:
  
  from - The added tables
- addFrom
  
  @Support void addFrom(Collection<? extends TableLike<?>> from)
  
  Add tables to the table product.
  
  Parameters:
  
  from - The added tables
- addJoin
  
  @Support void addJoin(TableLike<?> table, Condition condition)
  
  Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
  
  Parameters:
  
  table - The joined table
  
  condition - The joining condition
- addJoin
  
  @Support void addJoin(TableLike<?> table, Condition... conditions)
  
  Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
  
  Parameters:
  
  table - The joined table
  
  conditions - The joining conditions
- addJoin
  
  @Support void addJoin(TableLike<?> table, JoinType type, Condition condition)
  
  Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
  
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  condition - The joining condition
- addJoin
  
  @Support void addJoin(TableLike<?> table, JoinType type, Condition... conditions)
  
  Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
  
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  conditions - The joining conditions
- addJoin
  
  @Support(ORACLE) @Pro void addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)
  
  Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
  This adds a PARTITION BY clause to the right hand side of a OUTER JOIN expression.
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  conditions - The joining conditions
  
  partitionBy - The PARTITION BY expression
  
  See Also:
  
  TablePartitionByStep
- addJoin
  
  @Support(ORACLE) @Pro void addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)
  
  Joins the existing table product to a new table using conditions, connecting them with each other with Operator.AND.
  This adds a PARTITION BY clause to the right hand side of a OUTER JOIN expression.
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  conditions - The joining conditions
  
  partitionBy - The PARTITION BY expression
  
  See Also:
  
  TablePartitionByStep
- addJoinUsing
  
  @Support void addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)
  
  Joins the existing table product to a new table with a USING clause.
  If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
  
  Parameters:
  
  table - The joined table
  
  fields - The fields for the USING clause
- addJoinUsing
  
  @Support void addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)
  
  Joins the existing table product to a new table with a USING clause.
  If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
  
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  fields - The fields for the USING clause
- addJoinOnKey
  
  @Support void addJoinOnKey(TableLike<?> table, JoinType type) throws DataAccessException
  
  Joins the existing table product to a new table using a foreign key.
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  Throws:
  
  DataAccessException - If there is no non-ambiguous key definition known to jOOQ. Please note that if you evolve your schema, a previously non-ambiguous ON KEY clause can suddenly become ambiguous on an existing query, so use this clause with care.
  
  See Also:
  
  TableOnStep.onKey(ForeignKey)
- addJoinOnKey
  
  @Support void addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields) throws DataAccessException
  
  Joins the existing table product to a new table using a foreign key.
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  keyFields - The foreign key fields
  
  Throws:
  
  DataAccessException - If there is no non-ambiguous key definition known to jOOQ. Please note that if you evolve your schema, a previously non-ambiguous ON KEY clause can suddenly become ambiguous on an existing query, so use this clause with care.
  
  See Also:
  
  TableOnStep.onKey(ForeignKey)
- addJoinOnKey
  
  @Support void addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)
  
  Joins the existing table product to a new table using a foreign key.
  Parameters:
  
  table - The joined table
  
  type - The type of join
  
  key - The foreign key
  
  See Also:
  
  TableOnStep.onKey(ForeignKey)
- addGroupBy
  
  @Support void addGroupBy(GroupField... fields)
  
  Adds grouping fields.
  Calling this with an empty argument list will result in an empty GROUP BY () clause being rendered.
  
  Parameters:
  
  fields - The grouping fields
- addGroupBy
  
  @Support void addGroupBy(Collection<? extends GroupField> fields)
  
  Adds grouping fields.
  Calling this with an empty argument list will result in an empty GROUP BY () clause being rendered.
  
  Parameters:
  
  fields - The grouping fields
- setGroupByDistinct
  
  @Support(POSTGRES_14) void setGroupByDistinct(boolean groupByDistinct)
  
  Specifies the GROUP BY DISTINCT clause.
  This is mostly useful when combined with DSL.groupingSets(Field[]...) to remove duplicate grouping set results prior to aggregation and projection.
- addHaving
  
  @Support void addHaving(Condition condition)
  
  Adds a new condition to the having clause of the query, connecting it with each other with Operator.AND.
  
  Parameters:
  
  condition - The condition
- addHaving
  
  @Support void addHaving(Condition... conditions)
  
  Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.
  
  Parameters:
  
  conditions - The condition
- addHaving
  
  @Support void addHaving(Collection<? extends Condition> conditions)
  
  Adds new conditions to the having clause of the query, connecting them with each other with Operator.AND.
  
  Parameters:
  
  conditions - The condition
- addHaving
  
  @Support void addHaving(Operator operator, Condition condition)
  
  Adds a new condition to the having clause of query, connecting it with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  condition - The condition
- addHaving
  
  @Support void addHaving(Operator operator, Condition... conditions)
  
  Adds new conditions to the having clause of query, connecting them with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  conditions - The condition
- addHaving
  
  @Support void addHaving(Operator operator, Collection<? extends Condition> conditions)
  
  Adds new conditions to the having clause of query, connecting them with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  conditions - The condition
- addWindow
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addWindow(WindowDefinition... definitions)
  
  Adds new window definitions to the window clause of the query.
  
  Parameters:
  
  definitions - The definitions
- addWindow
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addWindow(Collection<? extends WindowDefinition> definitions)
  
  Adds new window definitions to the window clause of the query.
  
  Parameters:
  
  definitions - The definitions
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Condition condition)
  
  Adds a new condition to the qualify clause of the query, connecting it with each other with Operator.AND.
  
  Parameters:
  
  condition - The condition
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Condition... conditions)
  
  Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.
  
  Parameters:
  
  conditions - The condition
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Collection<? extends Condition> conditions)
  
  Adds new conditions to the qualify clause of the query, connecting them with each other with Operator.AND.
  
  Parameters:
  
  conditions - The condition
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Operator operator, Condition condition)
  
  Adds a new condition to the qualify clause of query, connecting it with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  condition - The condition
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Operator operator, Condition... conditions)
  
  Adds new conditions to the qualify clause of query, connecting them with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  conditions - The condition
- addQualify
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addQualify(Operator operator, Collection<? extends Condition> conditions)
  
  Adds new conditions to the qualify clause of query, connecting them with each other with operator.
  
  Parameters:
  
  operator - The operator to use to add the conditions to the existing conditions
  
  conditions - The condition
- addHint
  
  @Support void addHint(String hint)
  Add an Oracle-style hint to the select clause.
  Example:
  DSLContext create = DSL.using(configuration); create.select(field1, field2) .hint("/*+ALL_ROWS*/") .from(table1) .execute();
  
  You can also use this clause for any other database, that accepts hints or options at the same syntactic location, e.g. for MySQL's SQL_CALC_FOUND_ROWS option:
  create.select(field1, field2) .hint("SQL_CALC_FOUND_ROWS") .from(table1) .fetch();
  
  The outcome of such a query is this:
  SELECT [hint] field1, field2 FROM table1
  
  For SQL Server style table hints, see Table.with(String)
  See Also:
  
  Table.with(String)
- addOption
  
  @Support void addOption(String option)
  Add a SQL Server-style query hint to the select clause.
  Example:
  DSLContext create = DSL.using(configuration); create.select(field1, field2) .from(table1) .option("OPTION (OPTIMIZE FOR UNKNOWN)") .execute();
  
  You can also use this clause for any other database, that accepts hints or options at the same syntactic location, e.g. for DB2's isolation clause:
  create.select(field1, field2) .from(table1) .option("WITH RR USE AND KEEP EXCLUSIVE LOCKS") .execute();
  
  The outcome of such a query is this:
  SELECT field1, field2 FROM table1 [option]
  
  For SQL Server style table hints, see Table.with(String)
  See Also:
  
  Table.with(String)
- addConnectBy
  
  @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,YUGABYTEDB}) @Pro void addConnectBy(Condition condition)
  
  Add an Oracle-specific CONNECT BY clause to the query.
  Simple versions of this clause can be emulated using DSL.generateSeries(int, int).
- addConnectByNoCycle
  
  @Support({CUBRID,EXASOL,INFORMIX,ORACLE}) @Pro void addConnectByNoCycle(Condition condition)
  
  Add an Oracle-specific CONNECT BY NOCYCLE clause to the query.
- setConnectByStartWith
  
  @Support({CUBRID,EXASOL,INFORMIX,ORACLE,SNOWFLAKE}) @Pro void setConnectByStartWith(Condition condition)
  
  Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
- addConditions
  
  @Support void addConditions(Condition condition)
  
  Description copied from interface: ConditionProvider
  
  Adds a new condition to the query, connecting them to existing conditions with Operator.AND.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  Parameters:
  
  condition - The condition
- addConditions
  
  @Support void addConditions(Condition... conditions)
  
  Description copied from interface: ConditionProvider
  
  Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  Parameters:
  
  conditions - The condition
- addConditions
  
  @Support void addConditions(Collection<? extends Condition> conditions)
  
  Description copied from interface: ConditionProvider
  
  Adds new conditions to the query, connecting them to existing conditions with Operator.AND.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  Parameters:
  
  conditions - The condition
- addConditions
  
  @Support void addConditions(Operator operator, Condition condition)
  
  Description copied from interface: ConditionProvider
  
  Adds a new condition to the query, connecting them to existing conditions with the provided operator.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  condition - The condition
- addConditions
  
  @Support void addConditions(Operator operator, Condition... conditions)
  
  Description copied from interface: ConditionProvider
  
  Adds new conditions to the query, connecting them to existing conditions with the provided operator.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  conditions - The condition
- addConditions
  
  @Support void addConditions(Operator operator, Collection<? extends Condition> conditions)
  
  Description copied from interface: ConditionProvider
  
  Adds new conditions to the query, connecting them to existing conditions with the provided operator.
  
  Specified by:
  
  addConditions in interface ConditionProvider
  
  conditions - The condition
- addOrderBy
  
  @Support void addOrderBy(OrderField<?>... fields)
  
  Adds ordering fields.
  
  Parameters:
  
  fields - The ordering fields
- addOrderBy
  
  @Support void addOrderBy(Collection<? extends OrderField<?>> fields)
  
  Adds ordering fields.
  
  Parameters:
  
  fields - The ordering fields
- addOrderBy
  
  @Support void addOrderBy(int... fieldIndexes)
  
  Adds ordering fields.
  Indexes start at 1 in SQL!
  Note, you can use addOrderBy(DSL.val(1).desc()) or addOrderBy(DSL.literal(1).desc()) to apply descending ordering
  
  Parameters:
  
  fieldIndexes - The ordering fields
- setOrderBySiblings
  
  @Support({CUBRID,INFORMIX,ORACLE}) @Pro void setOrderBySiblings(boolean orderBySiblings)
  
  Indicate whether the SIBLINGS keyword should be used in an ORDER BY clause to form an ORDER SIBLINGS BY clause.
  This clause can be used only along with Oracle's CONNECT BY clause, to indicate that the hierarchical ordering should be preserved and elements of each hierarchy should be ordered among themselves.
  
  Parameters:
  
  orderBySiblings -
- addSeekAfter
  
  @Support void addSeekAfter(Field<?>... fields)
  
  Adds seeking fields.
  
  Parameters:
  
  fields - The seeking fields
- addSeekAfter
  
  @Support void addSeekAfter(Collection<? extends Field<?>> fields)
  
  Adds seeking fields.
  
  Parameters:
  
  fields - The seeking fields
- addSeekBefore
  
  @Deprecated @Support void addSeekBefore(Field<?>... fields)
  
  Deprecated.
  - [#7461] - SEEK BEFORE is not implemented correctly
  
  Adds seeking fields.
  
  Parameters:
  
  fields - The seeking fields
- addSeekBefore
  
  @Deprecated @Support void addSeekBefore(Collection<? extends Field<?>> fields)
  
  Deprecated.
  - [#7461] - SEEK BEFORE is not implemented correctly
  
  Adds seeking fields.
  
  Parameters:
  
  fields - The seeking fields
- addOffset
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addOffset(int offset)
  
  Add a 0-based OFFSET clause to the query.
  Offsets are 0-based as they describe the number of rows to skip.
  If there is no LIMIT … OFFSET or TOP clause in your RDBMS, or if your RDBMS does not natively support offsets, this is emulated with a ROW_NUMBER() window function and nested SELECT statements.
- addOffset
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addOffset(Number offset)
  
  Add a 0-based OFFSET clause to the query.
  Offsets are 0-based as they describe the number of rows to skip.
  If there is no LIMIT … OFFSET or TOP clause in your RDBMS, or if your RDBMS does not natively support offsets, this is emulated with a ROW_NUMBER() window function and nested SELECT statements.
- addOffset
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addOffset(Param<? extends Number> offset)
  
  Add a 0-based OFFSET clause to the query using a named parameter.
  Offsets are 0-based as they describe the number of rows to skip.
  If there is no LIMIT … OFFSET or TOP clause in your RDBMS, or if your RDBMS does not natively support offsets, this is emulated with a ROW_NUMBER() window function and nested SELECT statements.
- addLimit
  
  @Support void addLimit(int numberOfRows)
  
  Limit the results of this select.
  This is the same as calling addLimit(int, int) with offset = 0
  
  Parameters:
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support void addLimit(Number numberOfRows)
  
  Limit the results of this select.
  This is the same as calling addLimit(int, int) with offset = 0
  
  Parameters:
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Param<? extends Number> numberOfRows)
  
  Limit the results of this select 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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  This is the same as calling addLimit(int, int) with offset = 0
  
  Parameters:
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(int offset, int numberOfRows)
  
  Limit the results of this select.
  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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Number offset, Number numberOfRows)
  
  Limit the results of this select.
  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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Param<Integer> offset, int numberOfRows)
  
  Limit the results of this select.
  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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Param<? extends Number> offset, Number numberOfRows)
  
  Limit the results of this select.
  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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(int offset, Param<Integer> numberOfRows)
  
  Limit the results of this select 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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Number offset, Param<? extends Number> numberOfRows)
  
  Limit the results of this select 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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- addLimit
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void addLimit(Param<? extends Number> offset, Param<? extends Number> numberOfRows)
  
  Limit the results of this select 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 emulated with a ROW_NUMBER() window function and nested SELECT statements.
  
  Parameters:
  
  offset - The lowest offset starting at 0
  
  numberOfRows - The number of rows to return
- setLimitPercent
  
  @Support({H2,ORACLE12C,SQLSERVER,TERADATA}) void setLimitPercent(boolean percent)
  
  Add the PERCENT clause to a LIMIT clause.
- setWithTies
  
  @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) void setWithTies(boolean withTies)
  
  Add the WITH TIES clause to a LIMIT clause.
- setForUpdate
  
  @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,YUGABYTEDB}) void setForUpdate(boolean forUpdate)
  Sets the "FOR UPDATE" lock mode onto the query.
  
  Native implementation
  
  This has been observed to be supported by any of these dialects:
  
  DB2 FOR UPDATE and similar clauses
  
  Derby's FOR UPDATE clause
  
  H2's FOR UPDATE clause
  
  HSQLDB's FOR UPDATE clause
  
  MySQL's InnoDB locking reads
  
  Oracle's PL/SQL FOR UPDATE clause
  
  Postgres FOR UPDATE / FOR SHARE
  
  Emulation
  
  SQLDialect.SQLSERVER: jOOQ will try to lock the database record using WITH (ROWLOCK, UPDLOCK) hints.
  Not supported
  
  These dialects are known not to support the FOR UPDATE clause in regular SQL:
  
  SQLDialect.SQLITE
  
  If your dialect does not support this clause, jOOQ will still render it, if you apply it to your query. This might then cause syntax errors reported either by your database or your JDBC driver.
  You shouldn't combine this with setForShare(boolean)
  Parameters:
  
  forUpdate - The flag's value
- setForNoKeyUpdate
  
  @Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,YUGABYTEDB}) void setForNoKeyUpdate(boolean forNoKeyUpdate)
  
  Sets the "FOR NO KEY UPDATE" lock mode onto the query.
- setForUpdateOf
  
  @Deprecated(forRemoval=true, since="3.14") @Support({COCKROACHDB,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,SYBASE}) void setForUpdateOf(Field<?>... fields)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeOf(Field...)
  Some RDBMS allow for specifying the fields that should be locked by the FOR UPDATE clause, instead of the full row.
  This automatically sets the setForUpdate(boolean) flag, and unsets the setForShare(boolean) flag, if it was previously set.
  This has been observed to be natively supported by any of these dialects:
  
  DB2
  
  Derby
  
  H2
  
  HSQLDB
  
  Ingres
  
  Oracle
  
  Sybase
  
  Note, that SQLDialect.DB2 has some stricter requirements regarding the updatability of fields. Refer to the DB2 documentation for further details
  Parameters:
  
  fields - The fields that should be locked
- setForUpdateOf
  
  @Deprecated(forRemoval=true, since="3.14") @Support({COCKROACHDB,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,SYBASE}) void setForUpdateOf(Collection<? extends Field<?>> fields)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeOf(Collection)
  
  Some RDBMS allow for specifying the fields that should be locked by the FOR UPDATE clause, instead of the full row.
  See Also:
  
  setForUpdateOf(Field...)
- setForUpdateOf
  
  @Deprecated(forRemoval=true, since="3.14") @Support({AURORA_POSTGRES,COCKROACHDB,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MYSQL_8_0,ORACLE,POSTGRES,SQLSERVER,SYBASE,YUGABYTEDB}) void setForUpdateOf(Table<?>... tables)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeOf(Table...)
  Some RDBMS allow for specifying the tables that should be locked by the FOR UPDATE clause, instead of the full row.
  This automatically sets the setForUpdate(boolean) flag, and unsets the setForShare(boolean) flag, if it was previously set.
  This has been observed to be natively supported by any of these dialects:
  
  Postgres
  
  H2
  
  HSQLDB
  
  Sybase
  
  jOOQ emulates this by locking all known fields of [tables] for any of these dialects:
  
  DB2
  
  Derby
  
  Ingres
  
  Oracle
  Parameters:
  
  tables - The tables that should be locked
- setForUpdateWait
  
  @Deprecated(forRemoval=true, since="3.14") @Support({MARIADB_10_3,ORACLE}) void setForUpdateWait(int seconds)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeWait(int)
  Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will wait for some seconds, before aborting the lock acquirement if the lock is not available.
  This automatically sets the setForUpdate(boolean) flag, and unsets the setForShare(boolean) flag, if it was previously set.
  This has been observed to be supported by any of these dialects:
  
  Oracle
  Parameters:
  
  seconds - The number of seconds to wait for a lock
- setForUpdateNoWait
  
  @Deprecated(forRemoval=true, since="3.14") @Support({AURORA_POSTGRES,MARIADB_10_3,MYSQL_8_0,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) void setForUpdateNoWait()
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeNoWait()
  Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will not wait before aborting the lock acquirement if the lock is not available.
  This automatically sets the setForUpdate(boolean) flag, and unsets the setForShare(boolean) flag, if it was previously set.
  This has been observed to be supported by any of these dialects:
  
  Oracle
- setForUpdateSkipLocked
  
  @Deprecated(forRemoval=true, since="3.14") @Support({AURORA_POSTGRES,MYSQL_8_0,ORACLE,POSTGRES_9_5,SQLSERVER,YUGABYTEDB}) void setForUpdateSkipLocked()
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  [#5218] - 3.14.0 - Use setForLockModeSkipLocked()
  Some RDBMS allow for specifying the locking mode for the applied FOR UPDATE clause. In this case, the session will skip all locked rows from the select statement, whose lock is not available.
  This automatically sets the setForUpdate(boolean) flag, and unsets the setForShare(boolean) flag, if it was previously set.
  This has been observed to be supported by any of these dialects:
  
  Oracle
- setForShare
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,MARIADB,MYSQL,POSTGRES,YUGABYTEDB}) void setForShare(boolean forShare)
  Sets the "FOR SHARE" lock mode onto the query.
  This has been observed to be supported by any of these dialects:
  
  MySQL's InnoDB locking reads
  
  Postgres FOR UPDATE / FOR SHARE
  
  If your dialect does not support this clause, jOOQ will still render it, if you apply it to your query. This might then cause syntax errors reported either by your database or your JDBC driver.
  You shouldn't combine this with setForUpdate(boolean)
  Parameters:
  
  forShare - The flag's value
- setForKeyShare
  
  @Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,YUGABYTEDB}) void setForKeyShare(boolean forKeyShare)
  
  Sets the "FOR KEY SHARE" lock mode onto the query.
- setForLockModeOf
  
  @Support({DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,SYBASE}) void setForLockModeOf(Field<?>... fields)
  
  Some RDBMS allow for specifying the fields that should be locked by the FOR <lock_mode> clause, instead of the full row.
  In case no lock mode has been set yet, it will implicitly be set to UPDATE (i.e. setForUpdate(boolean)).
  Depending on the dialect and lock mode this flag may or may not be supported.
  Note, that SQLDialect.DB2 has some stricter requirements regarding the updatability of fields. Refer to the DB2 documentation for further details
  
  Parameters:
  
  fields - The fields that should be locked
- setForLockModeOf
  
  @Support({DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,SYBASE}) void setForLockModeOf(Collection<? extends Field<?>> fields)
  
  Some RDBMS allow for specifying the fields that should be locked by the FOR <lock_mode> clause, instead of the full row.
  See Also:
  
  setForLockModeOf(Field...)
- setForLockModeOf
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MYSQL_8_0,ORACLE,POSTGRES,SQLSERVER,SYBASE,YUGABYTEDB}) void setForLockModeOf(Table<?>... tables)
  
  Some RDBMS allow for specifying the tables that should be locked by the FOR <lock_mode> clause, instead of the full row.
  In case no lock mode has been set yet, it will implicitly be set to UPDATE (i.e. setForUpdate(boolean)).
  Depending on the dialect and lock mode this flag may or may not be supported.
  
  Parameters:
  
  tables - The tables that should be locked
- setForLockModeWait
  
  @Support({AURORA_MYSQL,AURORA_POSTGRES,MARIADB,MYSQL,ORACLE,POSTGRES}) void setForLockModeWait(int seconds)
  
  Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause. In this case, the session will wait for some seconds, before aborting the lock acquirement if the lock is not available.
  In case no lock mode has been set yet, it will implicitly be set to UPDATE (i.e. setForUpdate(boolean)).
  Depending on the dialect and lock mode this flag may or may not be supported.
  
  Parameters:
  
  seconds - The number of seconds to wait for a lock
- setForLockModeNoWait
  
  @Support({AURORA_POSTGRES,MARIADB_10_3,MYSQL_8_0,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) void setForLockModeNoWait()
  
  Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause. In this case, the session will not wait before aborting the lock acquirement if the lock is not available.
  In case no lock mode has been set yet, it will implicitly be set to UPDATE (i.e. setForUpdate(boolean)).
  Depending on the dialect and lock mode this flag may or may not be supported.
- setForLockModeSkipLocked
  
  @Support({AURORA_POSTGRES,MARIADB_10_6,MYSQL_8_0,ORACLE,POSTGRES_9_5,SQLSERVER,YUGABYTEDB}) void setForLockModeSkipLocked()
  
  Some RDBMS allow for specifying the locking mode for the applied FOR <lock_mode> clause. In this case, the session will skip all locked rows from the select statement, whose lock is not available.
  In case no lock mode has been set yet, it will implicitly be set to UPDATE (i.e. setForUpdate(boolean)).
  Depending on the dialect and lock mode this flag may or may not be supported.
- setForXMLRaw
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLRaw(boolean forXMLRaw)
  
  Add a FOR XML RAW clause to the end of the query.
- setForXMLRaw
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLRaw(boolean forXMLRaw, String elementName)
  
  Add a FOR XML RAW clause to the end of the query.
- setForXMLAuto
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLAuto(boolean forXMLAuto)
  
  Add a FOR XML AUTO clause to the end of the query.
- setForXMLPath
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLPath(boolean forXMLPath)
  
  Add a FOR XML PATH clause to the end of the query.
- setForXMLPath
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLPath(boolean forXMLPath, String elementName)
  
  Add a FOR XML PATH clause to the end of the query.
- setForXMLType
  
  @Support(SQLSERVER) @Pro void setForXMLType(boolean forXMLRoot)
  
  Add a FOR XML TYPE clause to the end of the query.
- setForXMLRoot
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLRoot(boolean forXMLRoot)
  
  Add a FOR XML ROOT clause to the end of the query.
- setForXMLRoot
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLRoot(boolean forXMLRoot, String rootName)
  
  Add a FOR XML ROOT clause to the end of the query.
- setForXMLElements
  
  @Support({DB2,ORACLE,POSTGRES,SQLSERVER,TERADATA}) @Pro void setForXMLElements(boolean forXMLElements)
  
  Add a FOR XML ELEMENTS clause to the end of the query.
- setForXMLElementsXsinil
  
  @Support(SQLSERVER) @Pro void setForXMLElementsXsinil(boolean forXMLElementsXsinil)
  
  Add a FOR XML ELEMENTS XSINIL clause to the end of the query.
- setForXMLElementsAbsent
  
  @Support(SQLSERVER) @Pro void setForXMLElementsAbsent(boolean forXMLElementsAbsent)
  
  Add a FOR XML ELEMENTS ABSENT clause to the end of the query.
- setForJSONB
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONB(boolean forJSONB)
  
  Whether the FOR JSON query should produce JSONB instead of JSON.
- setForJSONAuto
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONAuto(boolean forJSONAuto)
  
  Add a FOR JSON AUTO clause to the end of the query.
- setForJSONPath
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONPath(boolean forJSONPath)
  
  Add a FOR JSON PATH clause to the end of the query.
- setForJSONRoot
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONRoot(boolean forJSONRoot)
  
  Add a FOR JSON ROOT clause to the end of the query.
- setForJSONRoot
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONRoot(boolean forJSONRoot, String rootName)
  
  Add a FOR JSON ROOT clause to the end of the query.
- setForJSONIncludeNullValues
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONIncludeNullValues(boolean forJSONIncludeNullValues)
  
  Add a FOR JSON ROOT clause to the end of the query.
- setForJSONWithoutArrayWrapper
  
  @Support({AURORA_POSTGRES,COCKROACHDB,DB2_11,H2,MARIADB_10_5,MYSQL_5_7,ORACLE12C,POSTGRES,SQLSERVER,YUGABYTEDB}) @Pro void setForJSONWithoutArrayWrapper(boolean forJSONWithoutArrayWrapper)
  
  Add a FOR JSON ROOT clause to the end of the query.
- setWithCheckOption
  
  @Support(ORACLE) @Pro void setWithCheckOption()
  
  Add a WITH CHECK OPTION clause to the end of the subquery.
- setWithReadOnly
  
  @Support(ORACLE) @Pro void setWithReadOnly()
  
  Add a WITH READ ONLY clause to the end of the subquery.

Interface SelectQuery<R extends Record>

Method Summary

Methods inherited from interface org.jooq.Attachable

Methods inherited from interface org.jooq.AttachableQueryPart

Methods inherited from interface org.jooq.FieldLike

Methods inherited from interface org.jooq.Fields

Methods inherited from interface java.lang.Iterable

Methods inherited from interface org.jooq.Publisher

Methods inherited from interface org.reactivestreams.Publisher

Methods inherited from interface org.jooq.Query

Methods inherited from interface org.jooq.QueryPart

Methods inherited from interface org.jooq.ResultQuery

Methods inherited from interface org.jooq.Select

Methods inherited from interface org.jooq.TableLike

Method Details

addSelect

addSelect

setDistinct

addDistinctOn

addDistinctOn

setInto

setInto

addFrom

addFrom

addFrom

addJoin

addJoin

addJoin

addJoin

addJoin

addJoin

addJoinUsing

addJoinUsing

addJoinOnKey

addJoinOnKey

addJoinOnKey

addGroupBy

addGroupBy

setGroupByDistinct

addHaving

addHaving

addHaving

addHaving

addHaving

addHaving

addWindow

addWindow

addQualify

addQualify

addQualify

addQualify

addQualify

addQualify

addHint

addOption

addConnectBy

addConnectByNoCycle

setConnectByStartWith

addConditions

addConditions

addConditions

addConditions

addConditions

addConditions

addOrderBy

addOrderBy

addOrderBy

setOrderBySiblings

addSeekAfter

addSeekAfter

addSeekBefore

addSeekBefore

addOffset

addOffset

addOffset

addLimit

addLimit

addLimit

addLimit

addLimit