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.$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
.Apply theEXCEPT
(orMINUS
) set operation.Apply theEXCEPT ALL
set operation.Apply theINTERSECT
set operation.Select.intersectAll
(Select<? extends R> select) Apply theINTERSECT ALL
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.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> void Specify 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 CreateTableWithDataStep
Add theAS
clause to theCREATE TABLE
statement.@NotNull CreateViewFinalStep
Add anAS
clause to theCREATE VIEW
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.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.@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.<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 -
Uses of Select in org.jooq.impl
Modifier and TypeMethodDescriptiondefault @NotNull Select<?>
QOM.SelectIsNotNull.$field()
default @NotNull Select<?>
QOM.SelectIsNull.$field()
@NotNull Select<?>
QOM.Exists.$query()
@NotNull Select<?>
QOM.Unique.$query()
QOM.ArrayQuery.$select()
@Nullable Select<?>
QOM.CreateTable.$select()
SequenceImpl.nextvals
(int size) Modifier and TypeMethodDescription@NotNull QOM.Exists
@NotNull QOM.Unique
@NotNull QOM.CreateTable
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 <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)