Uses of Interface
org.jooq.Select
Packages that use 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 TypeInterfaceDescriptioninterfaceSelectConditionStep<R extends Record>interfaceSelectConnectByAfterStartWithConditionStep<R extends Record>interfaceSelectConnectByConditionStep<R extends Record>interfaceSelectConnectByStep<R extends Record>interfaceSelectCorrelatedSubqueryStep<R extends Record>interfaceSelectDistinctOnStep<R extends Record>interfaceSelectFinalStep<R extends Record>interfaceSelectForJSONCommonDirectivesStep<R extends Record>interfaceSelectForStep<R extends Record>interfaceSelectForUpdateOfStep<R extends Record>interfaceSelectForUpdateStep<R extends Record>interfaceSelectForUpdateWaitStep<R extends Record>interfaceSelectForXMLCommonDirectivesStep<R extends Record>interfaceSelectForXMLPathDirectivesStep<R extends Record>interfaceSelectForXMLRawDirectivesStep<R extends Record>interfaceSelectFromStep<R extends Record>interfaceSelectGroupByStep<R extends Record>interfaceSelectHavingConditionStep<R extends Record>interfaceSelectHavingStep<R extends Record>interfaceSelectIntoStep<R extends Record>interfaceSelectJoinStep<R extends Record>interfaceSelectLimitAfterOffsetStep<R extends Record>interfaceSelectLimitPercentAfterOffsetStep<R extends Record>interfaceSelectLimitPercentStep<R extends Record>interfaceSelectLimitStep<R extends Record>interfaceSelectOffsetStep<R extends Record>interfaceSelectOnConditionStep<R extends Record>interfaceSelectOptionalOnStep<R extends Record>interfaceSelectOptionStep<R extends Record>interfaceSelectOrderByStep<R extends Record>interfaceSelectQualifyConditionStep<R extends Record>interfaceSelectQualifyStep<R extends Record>interfaceSelectQuery<R extends Record>ASELECTstatement (model API).interfaceSelectSeekLimitStep<R extends Record>interfaceSelectSeekStep1<R extends Record,T1> interfaceSelectSeekStep10<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interfaceSelectSeekStep11<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interfaceSelectSeekStep12<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interfaceSelectSeekStep13<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interfaceSelectSeekStep14<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interfaceSelectSeekStep15<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interfaceSelectSeekStep16<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interfaceSelectSeekStep17<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interfaceSelectSeekStep18<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interfaceSelectSeekStep19<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interfaceSelectSeekStep2<R extends Record,T1, T2> interfaceSelectSeekStep20<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interfaceSelectSeekStep21<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interfaceSelectSeekStep22<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> interfaceSelectSeekStep3<R extends Record,T1, T2, T3> interfaceSelectSeekStep4<R extends Record,T1, T2, T3, T4> interfaceSelectSeekStep5<R extends Record,T1, T2, T3, T4, T5> interfaceSelectSeekStep6<R extends Record,T1, T2, T3, T4, T5, T6> interfaceSelectSeekStep7<R extends Record,T1, T2, T3, T4, T5, T6, T7> interfaceSelectSeekStep8<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8> interfaceSelectSeekStep9<R extends Record,T1, T2, T3, T4, T5, T6, T7, T8, T9> interfaceSelectSeekStepN<R extends Record>interfaceSelectSelectStep<R extends Record>interfaceSelectStartWithStep<R extends Record>interfaceSelectUnionStep<R extends Record>interfaceSelectWhereStep<R extends Record>interfaceSelectWindowStep<R extends Record>interfaceSelectWithTiesAfterOffsetStep<R extends Record>interfaceSelectWithTiesStep<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 ALLset operation.Apply theINTERSECTset operation.Select.intersectAll(Select<? extends R> select) Apply theINTERSECT ALLset 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()TheSELECTstatement defining thisTableOptions.TableType.VIEWorTableOptions.TableType.MATERIALIZED_VIEW.Apply theUNIONset operation.Apply theUNION ALLset operation.Modifier and TypeMethodDescription<T1> voidSpecify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<T1,T2> void Specify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<T1,T2, T3> void Specify a multi-column set clause for theUPDATEstatement.<T1,T2, T3, T4>
voidSpecify a multi-column set clause for theUPDATEstatement.<T1,T2, T3, T4, T5>
voidSpecify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.voidSpecify a multi-column set clause for theUPDATEstatement.@NotNull ConditionCombine this condition with an EXISTS clause using theOperator.ANDoperator.@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator@NotNull DivideByOnConditionStepCombine the currently assembled conditions with anEXISTSclause using theOperator.ANDoperator.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator and proceed to the next step.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with anEXISTSclause using theOperator.ANDoperator.@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ANDoperator@NotNull ConditionCondition.andNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using theOperator.ANDoperator.@NotNull DeleteConditionStep<R>DeleteConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ANDoperator@NotNull DivideByOnConditionStepDivideByOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with aNOT EXISTSclause using theOperator.ANDoperator.@NotNull InsertOnConflictConditionStep<R>InsertOnConflictConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ANDoperator 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.ANDoperator 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.ANDoperator 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.ANDoperator 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.ANDoperator 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.ANDoperator and proceed to the next step.@NotNull TableOnConditionStep<R>TableOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with aNOT EXISTSclause using theOperator.ANDoperator.@NotNull UpdateConditionStep<R>UpdateConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ANDoperator@NotNull CreateTableWithDataStepAdd theASclause to theCREATE TABLEstatement.@NotNull CreateViewFinalStepAdd anASclause to theCREATE VIEWstatement.@NotNull BetweenAndStep<R>Check if this subquery is within a range of two subqueries.@NotNull ConditionCheck 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 ConditionSelectCorrelatedSubqueryStep.betweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue) Check if this subquery is within a symmetric range of two subqueries.@NotNull ConditionField.compare(Comparator comparator, Select<? extends Record1<T>> query) Compare this field with a subselect using a dynamic comparator.@NotNull ConditionRow1.compare(Comparator comparator, Select<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow10.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 ConditionRow11.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 ConditionRow12.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 ConditionRow13.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 ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRowN.compare(Comparator comparator, Select<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionSelectCorrelatedSubqueryStep.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 ConditionTheEQoperator.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this subquery with another record for equality.@NotNull ConditionTheEQUALoperator, an alias for theEQoperator.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this subquery with another record for equality.Apply theEXCEPT(orMINUS) set operation.@NotNull SelectOrderByStep<R>Apply theEXCEPT(orMINUS) set operation.Apply theEXCEPT ALLset operation.@NotNull SelectOrderByStep<R>Apply theEXCEPT ALLset operation.intDSLContext.fetchCount(Select<?> query) booleanDSLContext.fetchExists(Select<?> query) Check if aSelectwould return any records, if it were executed.@NotNull ConditionTheGEoperator.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this subquery with another record for order.@NotNull ConditionField.greaterOrEqual(Select<? extends Record1<T>> arg2) TheGREATER_OR_EQUALoperator, an alias for theGEoperator.@NotNull ConditionRow1.greaterOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionRow2.greaterOrEqual(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionSelectCorrelatedSubqueryStep.greaterOrEqual(Select<? extends R> select) Compare this subquery with another record for order.@NotNull ConditionField.greaterThan(Select<? extends Record1<T>> arg2) TheGREATER_THANoperator, an alias for theGToperator.@NotNull ConditionRow1.greaterThan(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionRow2.greaterThan(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRowN.greaterThan(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionSelectCorrelatedSubqueryStep.greaterThan(Select<? extends R> select) Compare this subquery with another record for order.@NotNull ConditionTheGToperator.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this subquery with another record for order.@NotNull ConditionTheINoperator.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this subquery with another subquery for equality.Apply theINTERSECTset operation.@NotNull SelectOrderByStep<R>Apply theINTERSECTset operation.Select.intersectAll(Select<? extends R> select) Apply theINTERSECT ALLset operation.@NotNull SelectOrderByStep<R>SelectUnionStep.intersectAll(Select<? extends R> select) Apply theINTERSECT ALLset operation.@NotNull ConditionField.isDistinctFrom(Select<? extends Record1<T>> arg2) TheIS_DISTINCT_FROMoperator.@NotNull ConditionRow1.isDistinctFrom(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionRow2.isDistinctFrom(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionRowN.isDistinctFrom(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionSelectCorrelatedSubqueryStep.isDistinctFrom(Select<? extends R> select) Compare this subquery with another record for distinctness.@NotNull ConditionField.isNotDistinctFrom(Select<? extends Record1<T>> arg2) TheIS_NOT_DISTINCT_FROMoperator.@NotNull ConditionRow1.isNotDistinctFrom(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionRow13.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 ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionRow2.isNotDistinctFrom(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionRowN.isNotDistinctFrom(Select<? extends Record> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionSelectCorrelatedSubqueryStep.isNotDistinctFrom(Select<? extends R> select) Compare this subquery with another record for distinctness.@NotNull ConditionTheLEoperator.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this subquery with another record for order.@NotNull ConditionField.lessOrEqual(Select<? extends Record1<T>> arg2) TheLESS_OR_EQUALoperator, an alias for theLEoperator.@NotNull ConditionRow1.lessOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow14.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 ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionRow2.lessOrEqual(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRowN.lessOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.@NotNull ConditionSelectCorrelatedSubqueryStep.lessOrEqual(Select<? extends R> select) Compare this subquery with another record for order.@NotNull ConditionTheLESS_THANoperator, an alias for theLToperator.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this subquery with another record for order.@NotNull ConditionTheLToperator.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this subquery with another record for order.static final @NotNull TableOptionsTableOptions.materializedView(Select<?> select) Create a newTableOptionsobject for aTableOptions.TableType.MATERIALIZED_VIEW.@NotNull ConditionTheNEoperator.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare 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 ConditionSelectCorrelatedSubqueryStep.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 ConditionSelectCorrelatedSubqueryStep.notBetweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue) Check if this subquery is not within a symmetric range of two subqueries.@NotNull ConditionTheNOT_EQUALoperator, an alias for theNEoperator.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow15.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 ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this subquery with another record for non-equality.@NotNull ConditionTheNOT_INoperator.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow16.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 ConditionRow17.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 ConditionRow18.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 ConditionRow19.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionRow20.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 ConditionRow21.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 ConditionRow22.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 ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this subquery with another subquery for non-equality.@NotNull ConditionCombine this condition with an EXISTS clause using theOperator.ORoperator.@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator@NotNull DivideByOnConditionStepCombine the currently assembled conditions with anEXISTSclause using theOperator.ORoperator.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator and proceed to the next step.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with anEXISTSclause using theOperator.ORoperator.@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with an EXISTS clause using theOperator.ORoperator@NotNull ConditionCondition.orNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using theOperator.ORoperator.@NotNull DeleteConditionStep<R>DeleteConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ORoperator@NotNull DivideByOnConditionStepDivideByOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with aNOT EXISTSclause using theOperator.ORoperator.@NotNull InsertOnConflictConditionStep<R>InsertOnConflictConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ORoperator 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.ORoperator 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.ORoperator 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.ORoperator 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.ORoperator 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.ORoperator and proceed to the next step.@NotNull TableOnConditionStep<R>TableOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with aNOT EXISTSclause using theOperator.ORoperator.@NotNull UpdateConditionStep<R>UpdateConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using theOperator.ORoperatorAdd an else clause to the already constructed case statement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement.@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>InsertValuesStep12.select(Select<? extends Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> select) Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>InsertValuesStep13.select(Select<? extends Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> select) Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>InsertValuesStep14.select(Select<? extends Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> select) Use aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@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 aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>Use aSELECTstatement as the source of values for theINSERTstatementDeprecated, 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 aSELECTstatement as the source of values for theMERGEstatement@NotNull StatementInitialise this declaration.<T> @NotNull InsertOnDuplicateSetMoreStep<R>Set values forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.<T> @NotNull InsertSetMoreStep<R>Set a value for a field in theINSERTstatement.<T> @NotNull InsertSetMoreStep<R>Set a value for a field in theINSERTstatement.<T> @NotNull MergeMatchedSetMoreStep<R>Set values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.<T> @NotNull MergeNotMatchedSetMoreStep<R>Set values forINSERTin theMERGEstatement'sWHEN NOT MATCHEDclause.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementRow17.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 StatementRow18.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 StatementRow19.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 StatementAssign a value to this set of variables.@NotNull StatementRow20.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 StatementRow21.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 StatementRow22.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 StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.@NotNull StatementAssign a value to this set of variables.<T1> @NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<T1,T2> @NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<T1,T2, T3> @NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATEstatement.<T1,T2, T3, T4>
@NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.<T1,T2, T3, T4, T5>
@NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.<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 theUPDATEstatement.@NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.<T> @NotNull UpdateSetMoreStep<R>Set a value for a field in theUPDATEstatement.@NotNull StatementAssign a value to this variable.voidInsertQuery.setSelect(Collection<? extends Field<?>> fields, Select<?> select) Use aSELECTstatement as the source of values for theINSERTstatement.voidUse aSELECTstatement as the source of values for theINSERTstatement.Apply theUNIONset operation.@NotNull SelectOrderByStep<R>Apply theUNIONset operation.Apply theUNION ALLset operation.@NotNull SelectOrderByStep<R>Apply theUNION ALLset operation.<T> @NotNull JSONEntry<T>The JSON entry value.static final @NotNull TableOptionsCreate a newTableOptionsobject 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 EXISTSclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull SelectConditionStep<R>SelectWhereStep.whereExists(Select<?> select) Add aWHERE EXISTSclause to the query.Table.whereExists(Select<?> select) Add aWHERE EXISTSclause 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 EXISTSclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull SelectConditionStep<R>SelectWhereStep.whereNotExists(Select<?> select) Add aWHERE NOT EXISTSclause to the query.Table.whereNotExists(Select<?> select) Add aWHERE NOT EXISTSclause 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
Methods in org.jooq.impl that return SelectModifier 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) Methods in org.jooq.impl with parameters of type SelectModifier and TypeMethodDescription@NotNull QOM.Exists@NotNull QOM.Unique@NotNull QOM.CreateTablestatic <R extends Record>
@NotNull QuantifiedSelect<R>Create anALLquantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R>Create anANYquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull Field<T[]>The PostgreSQLarray(select)function.static @NotNull ConditionTheEXISTSfunction.intDefaultDSLContext.fetchCount(Select<?> query) booleanDefaultDSLContext.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 ConditionTheNOT EXISTSfunction.static @NotNull ConditionTheNOT UNIQUEfunction.A synonym forTableLike.asTable(), which might look a bit more fluent like this, to some users.static @NotNull ConditionTheUNIQUEfunction.static <T> @NotNull CaseConditionStep<T>Initialise aCasestatement.static <T> @NotNull CaseConditionStep<T>Initialise aCasestatement.
DSLContext.mergeInto(Table)