Uses of Interface
org.jooq.Select
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Select in org.jooq
Modifier and TypeInterfaceDescriptioninterface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
Modifier and TypeMethodDescriptionSelect.$connectBy
(Condition newConnectBy) Experimental query object model accessor method, see alsoQOM
.Select.$connectByNoCycle
(boolean newConnectByNoCycle) Experimental query object model accessor method, see alsoQOM
.Select.$connectByStartWith
(Condition newConnectByStartWith) Experimental query object model accessor method, see alsoQOM
.Select.$distinct
(boolean newDistinct) Experimental query object model accessor method, see alsoQOM
.Select.$distinctOn
(Collection<? extends SelectFieldOrAsterisk> newDistinctOn) Experimental query object model accessor method, see alsoQOM
.Select.$from
(Collection<? extends Table<?>> newFrom) Experimental query object model accessor method, see alsoQOM
.Select.$groupBy
(Collection<? extends GroupField> newGroupBy) Experimental query object model accessor method, see alsoQOM
.Select.$groupByDistinct
(boolean newGroupByDistinct) Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.Select.$limitPercent
(boolean newLimitPercent) Experimental query object model accessor method, see alsoQOM
.Select.$limitWithTies
(boolean newLimitWithTies) Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.Select.$orderBy
(Collection<? extends SortField<?>> newOrderBy) Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.@NotNull Select
<?> Select.$select
(Collection<? extends SelectFieldOrAsterisk> newSelect) Experimental query object model accessor method, see alsoQOM
.Experimental query object model accessor method, see alsoQOM
.Select.$window
(Collection<? extends WindowDefinition> newWindow) 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.Select.exceptDistinct
(Select<? extends R> select) Apply theEXCEPT
(orMINUS
) set operation.Apply theINTERSECT
set operation.Select.intersectAll
(Select<? extends R> select) Apply theINTERSECT ALL
set operation.Select.intersectDistinct
(Select<? extends R> select) Apply theINTERSECT
set operation.Sequence.nextvals
(int size) An expression to increment the sequence and get the next values.@Nullable Select
<?> Parser.parseSelect
(String sql) Parse a SQL string to a select statement.@Nullable Select
<?> Parser.parseSelect
(String sql, Object... bindings) Parse a SQL string to a select statement.final @Nullable Select
<?> TableOptions.select()
TheSELECT
statement defining thisTableOptions.TableType.VIEW
orTableOptions.TableType.MATERIALIZED_VIEW
.Apply theUNION
set operation.Apply theUNION ALL
set operation.Select.unionDistinct
(Select<? extends R> select) Apply theUNION DISTINCT
set operation.Modifier and TypeMethodDescription<T1> void
Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
voidUpdateQuery.addValues
(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
voidUpdateQuery.addValues
(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
voidUpdateQuery.addValues
(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
voidUpdateQuery.addValues
(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
voidUpdateQuery.addValues
(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
voidUpdateQuery.addValues
(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
voidUpdateQuery.addValues
(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
voidUpdateQuery.addValues
(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
voidUpdateQuery.addValues
(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
voidUpdateQuery.addValues
(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2> void Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
voidUpdateQuery.addValues
(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
voidUpdateQuery.addValues
(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
voidUpdateQuery.addValues
(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3>
voidSpecify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4>
voidSpecify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5>
voidSpecify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6>
voidUpdateQuery.addValues
(Row6<T1, T2, T3, T4, T5, T6> row, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7>
voidUpdateQuery.addValues
(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
voidUpdateQuery.addValues
(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
voidUpdateQuery.addValues
(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select) Specify a multi-column set clause for theUPDATE
statement.void
Specify a multi-column set clause for theUPDATE
statement.@NotNull Condition
Combine this condition with an EXISTS clause using theOperator.AND
operator.@NotNull DeleteConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with anEXISTS
clause using theOperator.AND
operator.@NotNull InsertOnConflictConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> Combine the currently assembled conditions with anEXISTS
clause using theOperator.AND
operator.@NotNull UpdateConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.AND
operator@NotNull Condition
Condition.andNotExists
(Select<?> select) Combine this condition with a NOT EXIST clause using theOperator.AND
operator.@NotNull DeleteConditionStep
<R> DeleteConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator@NotNull DivideByOnConditionStep
DivideByOnConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.AND
operator.@NotNull InsertOnConflictConditionStep
<R> InsertOnConflictConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> MergeOnConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep
<R> SelectConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> SelectHavingConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> SelectOnConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> SelectQualifyConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> TableOnConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.AND
operator.@NotNull UpdateConditionStep
<R> UpdateConditionStep.andNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.AND
operator@NotNull AlterViewFinalStep
Add theAS
clause to theALTER VIEW
statement.@NotNull CreateTableWithDataStep
Add theAS
clause to theCREATE TABLE
statement.@NotNull BetweenAndStep
<R> Check if this subquery is within a range of two subqueries.@NotNull Condition
Check if this subquery is within a range of two subqueries.@NotNull BetweenAndStepR
<R> SelectCorrelatedSubqueryStep.betweenSymmetric
(Select<? extends R> minValue) Check if this subquery is within a symmetric range of two subqueries.@NotNull Condition
SelectCorrelatedSubqueryStep.betweenSymmetric
(Select<? extends R> minValue, Select<? extends R> maxValue) Check if this subquery is within a symmetric range of two subqueries.@NotNull Condition
Field.compare
(Comparator comparator, Select<? extends Record1<T>> query) Compare this field with a subselect using a dynamic comparator.@NotNull Condition
Row1.compare
(Comparator comparator, Select<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row10.compare
(Comparator comparator, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row11.compare
(Comparator comparator, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row12.compare
(Comparator comparator, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row13.compare
(Comparator comparator, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row14.compare
(Comparator comparator, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row15.compare
(Comparator comparator, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row16.compare
(Comparator comparator, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row17.compare
(Comparator comparator, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row18.compare
(Comparator comparator, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row19.compare
(Comparator comparator, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row20.compare
(Comparator comparator, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row21.compare
(Comparator comparator, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row22.compare
(Comparator comparator, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
RowN.compare
(Comparator comparator, Select<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
SelectCorrelatedSubqueryStep.compare
(Comparator comparator, Select<? extends R> select) Compare this subquery with a subquery using a dynamic comparator.Add an else clause to the already constructed case statement@NotNull Condition
TheEQ
operator.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row17.eq
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row18.eq
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row19.eq
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row20.eq
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row21.eq
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row22.eq
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this subquery with another record for equality.@NotNull Condition
TheEQUAL
operator, an alias for theEQ
operator.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row16.equal
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row17.equal
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row18.equal
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row19.equal
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row20.equal
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row21.equal
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row22.equal
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this subquery with another record for equality.Apply theEXCEPT
(orMINUS
) set operation.@NotNull SelectOrderByStep
<R> Apply theEXCEPT
(orMINUS
) set operation.Apply theEXCEPT ALL
set operation.@NotNull SelectOrderByStep
<R> Apply theEXCEPT ALL
set operation.Select.exceptDistinct
(Select<? extends R> select) Apply theEXCEPT
(orMINUS
) set operation.@NotNull SelectOrderByStep
<R> SelectUnionStep.exceptDistinct
(Select<? extends R> select) Apply theEXCEPT
(orMINUS
) set operation.int
DSLContext.fetchCount
(Select<?> query) boolean
DSLContext.fetchExists
(Select<?> query) Check if aSelect
would return any records, if it were executed.@NotNull Condition
TheGE
operator.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row17.ge
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.ge
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.ge
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row20.ge
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.ge
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.ge
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this subquery with another record for order.@NotNull Condition
Field.greaterOrEqual
(Select<? extends Record1<T>> arg2) TheGREATER_OR_EQUAL
operator, an alias for theGE
operator.@NotNull Condition
Row1.greaterOrEqual
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row14.greaterOrEqual
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row15.greaterOrEqual
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row16.greaterOrEqual
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row17.greaterOrEqual
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.greaterOrEqual
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.greaterOrEqual
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.greaterOrEqual
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row20.greaterOrEqual
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.greaterOrEqual
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.greaterOrEqual
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterOrEqual
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
SelectCorrelatedSubqueryStep.greaterOrEqual
(Select<? extends R> select) Compare this subquery with another record for order.@NotNull Condition
Field.greaterThan
(Select<? extends Record1<T>> arg2) TheGREATER_THAN
operator, an alias for theGT
operator.@NotNull Condition
Row1.greaterThan
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row14.greaterThan
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row15.greaterThan
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row16.greaterThan
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row17.greaterThan
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.greaterThan
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.greaterThan
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.greaterThan
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row20.greaterThan
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.greaterThan
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.greaterThan
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
RowN.greaterThan
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
SelectCorrelatedSubqueryStep.greaterThan
(Select<? extends R> select) Compare this subquery with another record for order.@NotNull Condition
TheGT
operator.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row17.gt
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.gt
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.gt
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row20.gt
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.gt
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.gt
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this subquery with another record for order.@NotNull Condition
TheIN
operator.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row17.in
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row18.in
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row19.in
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row20.in
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row21.in
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Row22.in
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this subquery with another subquery for equality.Apply theINTERSECT
set operation.@NotNull SelectOrderByStep
<R> Apply theINTERSECT
set operation.Select.intersectAll
(Select<? extends R> select) Apply theINTERSECT ALL
set operation.@NotNull SelectOrderByStep
<R> SelectUnionStep.intersectAll
(Select<? extends R> select) Apply theINTERSECT ALL
set operation.Select.intersectDistinct
(Select<? extends R> select) Apply theINTERSECT
set operation.@NotNull SelectOrderByStep
<R> SelectUnionStep.intersectDistinct
(Select<? extends R> select) Apply theINTERSECT
set operation.@NotNull Condition
Field.isDistinctFrom
(Select<? extends Record1<T>> arg2) TheIS_DISTINCT_FROM
operator.@NotNull Condition
Row1.isDistinctFrom
(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row14.isDistinctFrom
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row15.isDistinctFrom
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row16.isDistinctFrom
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row17.isDistinctFrom
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row18.isDistinctFrom
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row19.isDistinctFrom
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row2.isDistinctFrom
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row20.isDistinctFrom
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row21.isDistinctFrom
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row22.isDistinctFrom
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN.isDistinctFrom
(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
SelectCorrelatedSubqueryStep.isDistinctFrom
(Select<? extends R> select) Compare this subquery with another record for distinctness.@NotNull Condition
Field.isNotDistinctFrom
(Select<? extends Record1<T>> arg2) TheIS_NOT_DISTINCT_FROM
operator.@NotNull Condition
Row1.isNotDistinctFrom
(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row13.isNotDistinctFrom
(Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row14.isNotDistinctFrom
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row15.isNotDistinctFrom
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row16.isNotDistinctFrom
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row17.isNotDistinctFrom
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row18.isNotDistinctFrom
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row19.isNotDistinctFrom
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row2.isNotDistinctFrom
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row20.isNotDistinctFrom
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row21.isNotDistinctFrom
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row22.isNotDistinctFrom
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN.isNotDistinctFrom
(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
SelectCorrelatedSubqueryStep.isNotDistinctFrom
(Select<? extends R> select) Compare this subquery with another record for distinctness.@NotNull Condition
TheLE
operator.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row17.le
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.le
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.le
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row20.le
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.le
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.le
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this subquery with another record for order.@NotNull Condition
Field.lessOrEqual
(Select<? extends Record1<T>> arg2) TheLESS_OR_EQUAL
operator, an alias for theLE
operator.@NotNull Condition
Row1.lessOrEqual
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row14.lessOrEqual
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row15.lessOrEqual
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row16.lessOrEqual
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row17.lessOrEqual
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.lessOrEqual
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.lessOrEqual
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.lessOrEqual
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row20.lessOrEqual
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.lessOrEqual
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.lessOrEqual
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
RowN.lessOrEqual
(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull Condition
SelectCorrelatedSubqueryStep.lessOrEqual
(Select<? extends R> select) Compare this subquery with another record for order.@NotNull Condition
TheLESS_THAN
operator, an alias for theLT
operator.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row15.lessThan
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row16.lessThan
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row17.lessThan
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.lessThan
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.lessThan
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row20.lessThan
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.lessThan
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.lessThan
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this subquery with another record for order.@NotNull Condition
TheLT
operator.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row17.lt
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row18.lt
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row19.lt
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row20.lt
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row21.lt
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row22.lt
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this subquery with another record for order.static final @NotNull TableOptions
TableOptions.materializedView
(Select<?> select) Create a newTableOptions
object for aTableOptions.TableType.MATERIALIZED_VIEW
.@NotNull Condition
TheNE
operator.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row17.ne
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row18.ne
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row19.ne
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row20.ne
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row21.ne
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row22.ne
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this subquery with another record for non-equality.@NotNull BetweenAndStepR
<R> SelectCorrelatedSubqueryStep.notBetween
(Select<? extends R> minValue) Check if this subquery is not within a range of two subqueries.@NotNull Condition
SelectCorrelatedSubqueryStep.notBetween
(Select<? extends R> minValue, Select<? extends R> maxValue) Check if this subquery is not within a range of two subqueries.@NotNull BetweenAndStepR
<R> SelectCorrelatedSubqueryStep.notBetweenSymmetric
(Select<? extends R> minValue) Check if this subquery is not within a symmetric range of two subqueries.@NotNull Condition
SelectCorrelatedSubqueryStep.notBetweenSymmetric
(Select<? extends R> minValue, Select<? extends R> maxValue) Check if this subquery is not within a symmetric range of two subqueries.@NotNull Condition
TheNOT_EQUAL
operator, an alias for theNE
operator.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row15.notEqual
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row16.notEqual
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row17.notEqual
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row18.notEqual
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row19.notEqual
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row20.notEqual
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row21.notEqual
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row22.notEqual
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this subquery with another record for non-equality.@NotNull Condition
TheNOT_IN
operator.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row16.notIn
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row17.notIn
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row18.notIn
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row19.notIn
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row20.notIn
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row21.notIn
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row22.notIn
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this subquery with another subquery for non-equality.@NotNull Condition
Combine this condition with an EXISTS clause using theOperator.OR
operator.@NotNull DeleteConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with anEXISTS
clause using theOperator.OR
operator.@NotNull InsertOnConflictConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> Combine the currently assembled conditions with anEXISTS
clause using theOperator.OR
operator.@NotNull UpdateConditionStep
<R> Combine the currently assembled conditions with an EXISTS clause using theOperator.OR
operator@NotNull Condition
Condition.orNotExists
(Select<?> select) Combine this condition with a NOT EXIST clause using theOperator.OR
operator.@NotNull DeleteConditionStep
<R> DeleteConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator@NotNull DivideByOnConditionStep
DivideByOnConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.OR
operator.@NotNull InsertOnConflictConditionStep
<R> InsertOnConflictConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> MergeOnConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep
<R> SelectConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> SelectHavingConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> SelectOnConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> SelectQualifyConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> TableOnConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with aNOT EXISTS
clause using theOperator.OR
operator.@NotNull UpdateConditionStep
<R> UpdateConditionStep.orNotExists
(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.OR
operatorAdd an else clause to the already constructed case statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement.@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep12.select
(Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep13.select
(Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep14.select
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep15.select
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep16.select
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep17.select
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep18.select
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep19.select
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep20.select
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep21.select
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> InsertValuesStep22.select
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statement@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statementDeprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep13.select
(Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep14.select
(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep15.select
(Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep16.select
(Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep17.select
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep18.select
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep19.select
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep20.select
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep21.select
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
MergeValuesStep22.select
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Deprecated, for removal: This API element is subject to removal in a future version.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
Use aSELECT
statement as the source of values for theMERGE
statement@NotNull Statement
Initialise this declaration.<T> @NotNull InsertOnDuplicateSetMoreStep
<R> Set values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.<T> @NotNull InsertSetMoreStep
<R> Set a value for a field in theINSERT
statement.<T> @NotNull InsertSetMoreStep
<R> Set a value for a field in theINSERT
statement.<T> @NotNull MergeMatchedSetMoreStep
<R> Set values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.<T> @NotNull MergeNotMatchedSetMoreStep
<R> Set values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row17.set
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> value) Assign a value to this set of variables.@NotNull Statement
Row18.set
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> value) Assign a value to this set of variables.@NotNull Statement
Row19.set
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> value) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row20.set
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> value) Assign a value to this set of variables.@NotNull Statement
Row21.set
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> value) Assign a value to this set of variables.@NotNull Statement
Row22.set
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> value) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.<T1> @NotNull UpdateFromStep
<R> Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> row, Select<? extends Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> row, Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> row, Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> row, Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> row, Select<? extends Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> row, Select<? extends Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> row, Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> row, Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> row, Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2> @NotNull UpdateFromStep <R> Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> row, Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> row, Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row, Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3>
@NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4>
@NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5>
@NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row6<T1, T2, T3, T4, T5, T6> row, Select<? extends Record6<T1, T2, T3, T4, T5, T6>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select) Specify a multi-column set clause for theUPDATE
statement.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select) Specify a multi-column set clause for theUPDATE
statement.@NotNull UpdateFromStep
<R> Specify a multi-column set clause for theUPDATE
statement.<T> @NotNull UpdateSetMoreStep
<R> Set a value for a field in theUPDATE
statement.@NotNull Statement
Assign a value to this variable.void
InsertQuery.setSelect
(Collection<? extends Field<?>> fields, Select<?> select) Use aSELECT
statement as the source of values for theINSERT
statement.void
Use aSELECT
statement as the source of values for theINSERT
statement.Apply theUNION
set operation.@NotNull SelectOrderByStep
<R> Apply theUNION
set operation.Apply theUNION ALL
set operation.@NotNull SelectOrderByStep
<R> Apply theUNION ALL
set operation.Select.unionDistinct
(Select<? extends R> select) Apply theUNION DISTINCT
set operation.@NotNull SelectOrderByStep
<R> SelectUnionStep.unionDistinct
(Select<? extends R> select) Apply theUNION DISTINCT
set operation.<T> @NotNull JSONEntry
<T> The JSON entry value.static final @NotNull TableOptions
Create a newTableOptions
object for aTableOptions.TableType.VIEW
.<T> @NotNull CaseConditionStep
<T> This construct can be used to create expressions of the type<T> @NotNull CaseConditionStep
<T> This construct can be used to create expressions of the type@NotNull CaseConditionStep
<T> Compare a condition to the already constructed case statement, return result if the condition holds true@NotNull CaseConditionStep
<T> Compare a condition to the already constructed case statement, return result if the condition holds true<T> @NotNull CaseWhenStep
<V, T> Compare a value to the already constructed case statement, return result if values are equal.<T> @NotNull CaseWhenStep
<V, T> Compare a value to the already constructed case statement, return result if values are equal.@NotNull DeleteConditionStep
<R> DeleteWhereStep.whereExists
(Select<?> select) Add an EXISTS clause to the query.@NotNull InsertOnConflictConditionStep
<R> InsertOnConflictWhereStep.whereExists
(Select<?> select) Add aWHERE EXISTS
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull SelectConditionStep
<R> SelectWhereStep.whereExists
(Select<?> select) Add aWHERE EXISTS
clause to the query.Table.whereExists
(Select<?> select) Add aWHERE EXISTS
clause to the table.@NotNull UpdateConditionStep
<R> UpdateWhereStep.whereExists
(Select<?> select) Add an EXISTS clause to the query@NotNull DeleteConditionStep
<R> DeleteWhereStep.whereNotExists
(Select<?> select) Add a NOT EXISTS clause to the query.@NotNull InsertOnConflictConditionStep
<R> InsertOnConflictWhereStep.whereNotExists
(Select<?> select) Add aWHERE NOT EXISTS
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull SelectConditionStep
<R> SelectWhereStep.whereNotExists
(Select<?> select) Add aWHERE NOT EXISTS
clause to the query.Table.whereNotExists
(Select<?> select) Add aWHERE NOT EXISTS
clause to the table.@NotNull UpdateConditionStep
<R> UpdateWhereStep.whereNotExists
(Select<?> select) Add a NOT EXISTS clause to the query@NotNull Condition
Combine this condition with an EXISTS clause using theOperator.XOR
operator.@NotNull Condition
Condition.xorNotExists
(Select<?> select) Combine this condition with a NOT EXIST clause using theOperator.XOR
operator. -
Uses of Select in org.jooq.impl
Modifier and TypeMethodDescription@Nullable Select
<?> QOM.AlterView.$as()
default @NotNull Select
<?> QOM.SelectIsNotNull.$field()
default @NotNull Select
<?> QOM.SelectIsNull.$field()
QOM.ArrayQuery.$query()
default @NotNull Select
<?> QOM.Exists.$query()
QOM.QuantifiedSelect.$query()
default @NotNull Select
<?> QOM.Unique.$query()
@Nullable Select
<?> QOM.CreateTable.$select()
@Nullable Select
<?> QOM.Insert.$select()
SequenceImpl.nextvals
(int size) Modifier and TypeMethodDescription@NotNull QOM.AlterView
default @NotNull QOM.Exists
default @NotNull QOM.QuantifiedSelect
<R> default @NotNull QOM.Unique
@NotNull QOM.CreateTable
@NotNull QOM.Insert
<?> static <R extends Record>
@NotNull QuantifiedSelect<R> Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R> Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull Field
<T[]> The PostgreSQLarray(select)
function.static @NotNull Condition
TheEXISTS
function.int
DefaultDSLContext.fetchCount
(Select<?> query) boolean
DefaultDSLContext.fetchExists
(Select<?> query) static <T> @NotNull Field
<T> Transform a subquery into a correlated subquery.static @NotNull JSONObjectNullStep
<JSONB> DSL.jsonbObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry
<T> A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static @NotNull JSONObjectNullStep
<JSON> DSL.jsonObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static @NotNull Condition
TheNOT EXISTS
function.static @NotNull Condition
TheNOT UNIQUE
function.A synonym forTableLike.asTable()
, which might look a bit more fluent like this, to some users.static @NotNull Condition
TheUNIQUE
function.static <T> @NotNull CaseConditionStep
<T> Initialise aCase
statement.static <T> @NotNull CaseConditionStep
<T> Initialise aCase
statement.
DSLContext.mergeInto(Table)