- Type Parameters:
R
- The record type being returned by this query
- All Superinterfaces:
Attachable
,AttachableQueryPart
,FieldLike
,FieldOrRowOrSelect
,Fields
,Flow.Publisher<R>
,Iterable<R>
,Publisher<R>
,org.reactivestreams.Publisher<R>
,Query
,QueryPart
,ResultQuery<R>
,Serializable
,Statement
,TableLike<R>
- All Known Subinterfaces:
SelectConditionStep<R>
,SelectConnectByAfterStartWithConditionStep<R>
,SelectConnectByConditionStep<R>
,SelectConnectByStep<R>
,SelectCorrelatedSubqueryStep<R>
,SelectDistinctOnStep<R>
,SelectFinalStep<R>
,SelectForJSONCommonDirectivesStep<R>
,SelectForStep<R>
,SelectForUpdateOfStep<R>
,SelectForUpdateStep<R>
,SelectForUpdateWaitStep<R>
,SelectForXMLCommonDirectivesStep<R>
,SelectForXMLPathDirectivesStep<R>
,SelectForXMLRawDirectivesStep<R>
,SelectFromStep<R>
,SelectGroupByStep<R>
,SelectHavingConditionStep<R>
,SelectHavingStep<R>
,SelectIntoStep<R>
,SelectJoinStep<R>
,SelectLimitAfterOffsetStep<R>
,SelectLimitPercentAfterOffsetStep<R>
,SelectLimitPercentStep<R>
,SelectLimitStep<R>
,SelectOffsetStep<R>
,SelectOnConditionStep<R>
,SelectOptionalOnStep<R>
,SelectOptionStep<R>
,SelectOrderByStep<R>
,SelectQualifyConditionStep<R>
,SelectQualifyStep<R>
,SelectQuery<R>
,SelectSeekLimitStep<R>
,SelectSeekStep1<R,
,T1> SelectSeekStep10<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> SelectSeekStep11<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> SelectSeekStep12<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> SelectSeekStep13<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> SelectSeekStep14<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> SelectSeekStep15<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> SelectSeekStep16<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> SelectSeekStep17<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> SelectSeekStep18<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> SelectSeekStep19<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> SelectSeekStep2<R,
,T1, T2> SelectSeekStep20<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> SelectSeekStep21<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> SelectSeekStep22<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> SelectSeekStep3<R,
,T1, T2, T3> SelectSeekStep4<R,
,T1, T2, T3, T4> SelectSeekStep5<R,
,T1, T2, T3, T4, T5> SelectSeekStep6<R,
,T1, T2, T3, T4, T5, T6> SelectSeekStep7<R,
,T1, T2, T3, T4, T5, T6, T7> SelectSeekStep8<R,
,T1, T2, T3, T4, T5, T6, T7, T8> SelectSeekStep9<R,
,T1, T2, T3, T4, T5, T6, T7, T8, T9> SelectSeekStepN<R>
,SelectSelectStep<R>
,SelectStartWithStep<R>
,SelectUnionStep<R>
,SelectWhereStep<R>
,SelectWindowStep<R>
,SelectWithTiesAfterOffsetStep<R>
,SelectWithTiesStep<R>
public non-sealed interface Select<R extends Record>
extends ResultQuery<R>, TableLike<R>, FieldLike, FieldOrRowOrSelect
A
SELECT
statement.
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME)
.from(ACTOR)
.fetch();
Instances can be created using DSL.select(SelectFieldOrAsterisk...)
,
or DSLContext.selectQuery()
and overloads.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@Nullable Condition
Experimental query object model accessor method, see alsoQOM
.$connectBy
(Condition newConnectBy) Experimental query object model accessor method, see alsoQOM
.boolean
Experimental query object model accessor method, see alsoQOM
.$connectByNoCycle
(boolean newConnectByNoCycle) Experimental query object model accessor method, see alsoQOM
.@Nullable Condition
Experimental query object model accessor method, see alsoQOM
.$connectByStartWith
(Condition newConnectByStartWith) Experimental query object model accessor method, see alsoQOM
.boolean
Experimental query object model accessor method, see alsoQOM
.$distinct
(boolean newDistinct) Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>
Experimental query object model accessor method, see alsoQOM
.$distinctOn
(Collection<? extends SelectFieldOrAsterisk> newDistinctOn) Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends Table<?>>
$from()
Experimental query object model accessor method, see alsoQOM
.$from
(Collection<? extends Table<?>> newFrom) Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends GroupField>
$groupBy()
Experimental query object model accessor method, see alsoQOM
.$groupBy
(Collection<? extends GroupField> newGroupBy) Experimental query object model accessor method, see alsoQOM
.boolean
Experimental query object model accessor method, see alsoQOM
.$groupByDistinct
(boolean newGroupByDistinct) Experimental query object model accessor method, see alsoQOM
.@Nullable Condition
$having()
Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.$limit()
Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.boolean
Experimental query object model accessor method, see alsoQOM
.$limitPercent
(boolean newLimitPercent) Experimental query object model accessor method, see alsoQOM
.boolean
Experimental query object model accessor method, see alsoQOM
.$limitWithTies
(boolean newLimitWithTies) Experimental query object model accessor method, see alsoQOM
.$offset()
Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends SortField<?>>
$orderBy()
Experimental query object model accessor method, see alsoQOM
.$orderBy
(Collection<? extends SortField<?>> newOrderBy) Experimental query object model accessor method, see alsoQOM
.@Nullable Condition
$qualify()
Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends SelectFieldOrAsterisk>
$select()
Experimental query object model accessor method, see alsoQOM
.@NotNull Select<?>
$select
(Collection<? extends SelectFieldOrAsterisk> newSelect) Experimental query object model accessor method, see alsoQOM
.@Nullable Condition
$where()
Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends WindowDefinition>
$window()
Experimental query object model accessor method, see alsoQOM
.$window
(Collection<? extends WindowDefinition> newWindow) Experimental query object model accessor method, see alsoQOM
.@Nullable QOM.With
$with()
Experimental query object model accessor method, see alsoQOM
.@NotNull Select<?>
Experimental query object model accessor method, see alsoQOM
.Apply theEXCEPT
(orMINUS
) set operation.Apply theEXCEPT ALL
set operation.All fields selected in this queryApply theINTERSECT
set operation.intersectAll
(Select<? extends R> select) Apply theINTERSECT ALL
set operation.Apply theUNION
set operation.Apply theUNION ALL
set operation.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.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 org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
cancel, 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, forEach, getRecordType, getResult, intern, intern, intern, intern, iterator, keepStatement, maxRows, poolable, queryTimeout, resultSetConcurrency, resultSetHoldability, resultSetType, spliterator, stream
Methods inherited from interface org.jooq.TableLike
asMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable
-
Method Details
-
union
Apply theUNION
set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
unionAll
Apply theUNION ALL
set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
except
@NotNull @CheckReturnValue @Support({ASE,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB_10_3,MEMSQL,MYSQL_8_0_31,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Select<R> except(Select<? extends R> select) Apply theEXCEPT
(orMINUS
) set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
exceptAll
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,HSQLDB,MARIADB_10_5,MYSQL_8_0_31,ORACLE20C,POSTGRES,TERADATA,YUGABYTEDB}) @NotNull Select<R> exceptAll(Select<? extends R> select) Apply theEXCEPT ALL
set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
intersect
@NotNull @CheckReturnValue @Support({ASE,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB_10_3,MEMSQL,MYSQL_8_0_31,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull Select<R> intersect(Select<? extends R> select) Apply theINTERSECT
set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
intersectAll
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,HSQLDB,MARIADB_10_5,MYSQL_8_0_31,ORACLE20C,POSTGRES,TERADATA,YUGABYTEDB}) @NotNull Select<R> intersectAll(Select<? extends R> select) Apply theINTERSECT ALL
set operation.- Throws:
IllegalArgumentException
- If the argument select has the same identity as this select. The jOOQ 3.x API is mutable, which means that calls to the DSL API mutate this instance. Adding this instance as an set operation argument would lead to aStackOverflowError
when generating the SQL.
-
getSelect
All fields selected in this query -
$with
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$with
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$select
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$select
@Experimental @CheckReturnValue @NotNull @NotNull Select<?> $select(Collection<? extends SelectFieldOrAsterisk> newSelect) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$distinct
@Experimental boolean $distinct()Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$distinct
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$distinctOn
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$distinctOn
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $distinctOn(Collection<? extends SelectFieldOrAsterisk> newDistinctOn) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$from
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$from
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $from(Collection<? extends Table<?>> newFrom) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$where
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$where
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$groupBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$groupBy
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $groupBy(Collection<? extends GroupField> newGroupBy) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$groupByDistinct
@Experimental boolean $groupByDistinct()Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$groupByDistinct
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $groupByDistinct(boolean newGroupByDistinct) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$having
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$having
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$window
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$window
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $window(Collection<? extends WindowDefinition> newWindow) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$qualify
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$qualify
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$orderBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$orderBy
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $orderBy(Collection<? extends SortField<?>> newOrderBy) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limit
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limit
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $limit(Field<? extends Number> newLimit) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limitPercent
@Experimental boolean $limitPercent()Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limitPercent
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limitWithTies
@Experimental boolean $limitWithTies()Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$limitWithTies
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $limitWithTies(boolean newLimitWithTies) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$offset
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$offset
@Experimental @CheckReturnValue @NotNull @NotNull Select<R> $offset(Field<? extends Number> newOffset) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectByNoCycle
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectByNoCycle
@Experimental @CheckReturnValue @Pro @NotNull @NotNull Select<R> $connectByNoCycle(boolean newConnectByNoCycle) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectByStartWith
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$connectByStartWith
@Experimental @CheckReturnValue @Pro @NotNull @NotNull Select<R> $connectByStartWith(Condition newConnectByStartWith) Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk.
-