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 TypeMethodDescriptionApply 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.@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> voidSpecify 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> voidSpecify a multi-column set clause for theUPDATEstatement.<T1, T2, T3, T4>
voidSpecify a multi-column set clause for theUPDATEstatement.<T1, T2, T3, T4, T5>
voidUpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)Specify 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 anASclause 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 ConditionRow8.compare(Comparator comparator, Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow9.compare(Comparator comparator, Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare 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 Conditionthis = (Select<?> ...).@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 ConditionRow13.eq(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 for equality.@NotNull ConditionRow14.eq(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 equality.@NotNull ConditionRow15.eq(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 equality.@NotNull ConditionRow16.eq(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.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 Conditionthis = (Select<?> ...).@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 ConditionRow13.equal(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 for equality.@NotNull ConditionRow14.equal(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 equality.@NotNull ConditionRow15.equal(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 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 Conditionthis >= (Select<?> ...).@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 ConditionRow13.ge(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 for order.@NotNull ConditionRow14.ge(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.ge(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.ge(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.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>> query)this >= (Select<?> ...).@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 ConditionRow11.greaterOrEqual(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow12.greaterOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow13.greaterOrEqual(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 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>> query)this > (Select<?> ...).@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 ConditionRow12.greaterThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow13.greaterThan(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 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 Conditionthis > (Select<?> ...).@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 ConditionRow13.gt(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 for order.@NotNull ConditionRow14.gt(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.gt(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.gt(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.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 ConditionCreate a condition to check this field against a subquery.@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 ConditionRow13.in(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 for equality.@NotNull ConditionRow14.in(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 equality.@NotNull ConditionRow15.in(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 equality.@NotNull ConditionRow16.in(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.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>> select)Create a condition to check if this field isDISTINCTfrom another field.@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 ConditionRow11.isDistinctFrom(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow12.isDistinctFrom(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow13.isDistinctFrom(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.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>> select)Create a condition to check if this field isNOT DISTINCTfrom another field.@NotNull ConditionRow1.isNotDistinctFrom(Select<? extends Record1<T1>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow10.isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow11.isNotDistinctFrom(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow12.isNotDistinctFrom(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare 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 Conditionthis <= (Select<?> ...).@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 ConditionRow13.le(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 for order.@NotNull ConditionRow14.le(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.le(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.le(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.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>> query)this <= (Select<?> ...).@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 ConditionRow12.lessOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow13.lessOrEqual(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 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 Conditionthis < (Select<?> ...).@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 ConditionRow12.lessThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow13.lessThan(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 for order.@NotNull ConditionRow14.lessThan(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.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 Conditionthis < (Select<?> ...).@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 ConditionRow13.lt(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 for order.@NotNull ConditionRow14.lt(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.lt(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.lt(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.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 @NotNull TableOptionsTableOptions.materializedView(Select<?> select)Create a newTableOptionsobject for aTableOptions.TableType.MATERIALIZED_VIEW.@NotNull Conditionthis != (Select<?> ...).@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 ConditionRow13.ne(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 for non-equality.@NotNull ConditionRow14.ne(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 non-equality.@NotNull ConditionRow15.ne(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.ne(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.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 Conditionthis != (Select<?> ...).@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 ConditionRow12.notEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow13.notEqual(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 for non-equality.@NotNull ConditionRow14.notEqual(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 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 ConditionCreate a condition to check this field against a subquery.@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 ConditionRow13.notIn(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 for non-equality.@NotNull ConditionRow14.notIn(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 non-equality.@NotNull ConditionRow15.notIn(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.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>InsertValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)Use aSELECTstatement as the source of values for theINSERTstatement@NotNull InsertOnDuplicateStep<R>InsertValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)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.MergeValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> 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)MergeValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> 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)MergeValuesStep12.select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> 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)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 ...<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 MATCHED clause.@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 StatementRow13.set(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> value)Assign a value to this set of variables.@NotNull StatementRow14.set(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> value)Assign a value to this set of variables.@NotNull StatementRow15.set(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> value)Assign a value to this set of variables.@NotNull StatementRow16.set(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> value)Assign 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>UpdateSetFirstStep.set(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)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 @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 ...@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 ...@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 SelectMethods in org.jooq.impl with parameters of type SelectModifier and TypeMethodDescriptionstatic <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 ConditionCreate an exists condition.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.Get theMULTISEToperator to nest subqueries.static @NotNull ConditionCreate a not exists condition.static @NotNull ConditionCreate a not unique condition.A synonym forTableLike.asTable(), which might look a bit more fluent like this, to some users.static @NotNull ConditionCreate a unique condition.static <T> @NotNull CaseConditionStep<T>Initialise aCasestatement.static <T> @NotNull CaseConditionStep<T>Initialise aCasestatement.
DSLContext.mergeInto(Table)