Uses of Interface
org.jooq.Select

Packages that use Select

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.
org.jooq.util.postgres	The org.jooq.util.ase package contains classes related to the SQLDialect.POSTGRES dialect.

Uses of Select in org.jooq

Subinterfaces of Select in org.jooq

Modifier and Type	Interface and Description
interface	SelectConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectDistinctOnStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFinalStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateOfStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateWaitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFromStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectGroupByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectIntoStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectJoinStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOnConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionalOnStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOrderByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQuery<R extends Record> A query for data selection
interface	SelectSeekLimitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep1<R extends Record,T1> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep2<R extends Record,T1,T2> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep3<R extends Record,T1,T2,T3> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep4<R extends Record,T1,T2,T3,T4> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStepN<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSelectStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectStartWithStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectUnionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWhereStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWindowStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.

Methods in org.jooq that return Select

Modifier and Type	Method and Description
Select<R>	Select.except(Select<? extends R> select) Combine with other selects
Select<R>	Select.intersect(Select<? extends R> select) Combine with other selects
Select<R>	Select.union(Select<? extends R> select) Combine with other selects
Select<R>	Select.unionAll(Select<? extends R> select) Combine with other selects

Methods in org.jooq with parameters of type Select

Modifier and Type	Method and Description
<T1> void	UpdateQuery.addValues(Row1<T1> row, Select<? extends Record1<T1>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> void	UpdateQuery.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 the UPDATE statement.
<T1,T2> void	UpdateQuery.addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3> void	UpdateQuery.addValues(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4> void	UpdateQuery.addValues(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5> void	UpdateQuery.addValues(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8> void	UpdateQuery.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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> void	UpdateQuery.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 the UPDATE statement.
UpdateConditionStep<R>	UpdateConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
TableOnConditionStep	TableOnConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.
SelectOnConditionStep<R>	SelectOnConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.andExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
Condition	Condition.andExists(Select<?> select) Combine this condition with an EXISTS clause using the Operator.AND operator.
UpdateConditionStep<R>	UpdateConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
TableOnConditionStep	TableOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.
SelectOnConditionStep<R>	SelectOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.andNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
Condition	Condition.andNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using the Operator.AND operator.
WithStep	WithAsStep.as(Select<?> select) Associate a subselect with a common table expression's table and column names.
CreateViewFinalStep	CreateViewAsStep.as(Select<? extends R> select) Add an AS clause to the CREATE VIEW statement.
CreateTableOnCommitStep	CreateTableAsStep.as(Select<? extends R> select) Add an AS clause to the CREATE TABLE statement.
<R extends Record> CommonTableExpression<R>	Name.as(Select<R> select) Specify a subselect to refer to by the Name to form a common table expression.
<R extends Record> CommonTableExpression<R>	DerivedColumnList.as(Select<R> select) Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
Condition	RowN.compare(Comparator comparator, Select<? extends Record> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Field.compare(Comparator comparator, Select<? extends Record1<T>> query) Compare this field with a subselect using a dynamic comparator.
Condition	Row1.compare(Comparator comparator, Select<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row10.compare(Comparator comparator, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row11.compare(Comparator comparator, Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row12.compare(Comparator comparator, Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row13.compare(Comparator comparator, Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row14.compare(Comparator comparator, Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row15.compare(Comparator comparator, Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row16.compare(Comparator comparator, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row17.compare(Comparator comparator, Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row18.compare(Comparator comparator, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row19.compare(Comparator comparator, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row2.compare(Comparator comparator, Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row20.compare(Comparator comparator, Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row21.compare(Comparator comparator, Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row22.compare(Comparator comparator, Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row3.compare(Comparator comparator, Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row4.compare(Comparator comparator, Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row5.compare(Comparator comparator, Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row6.compare(Comparator comparator, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row7.compare(Comparator comparator, Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect using a dynamic comparator.
Condition	Row8.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.
Condition	Row9.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.
Condition	RowN.eq(Select<? extends Record> select) Compare this row value expression with a subselect for equality.
Condition	Field.eq(Select<? extends Record1<T>> query) this = (Select<?
Condition	Row1.eq(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.
Condition	Row10.eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for equality.
Condition	Row11.eq(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for equality.
Condition	Row12.eq(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 equality.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.eq(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for equality.
Condition	Row18.eq(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for equality.
Condition	Row19.eq(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.eq(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row20.eq(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for equality.
Condition	Row21.eq(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for equality.
Condition	Row22.eq(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for equality.
Condition	Row3.eq(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for equality.
Condition	Row4.eq(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality.
Condition	Row5.eq(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for equality.
Condition	Row6.eq(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for equality.
Condition	Row7.eq(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for equality.
Condition	Row8.eq(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for equality.
Condition	Row9.eq(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for equality.
Condition	RowN.equal(Select<? extends Record> select) Compare this row value expression with a subselect for equality.
Condition	Field.equal(Select<? extends Record1<T>> query) this = (Select<?
Condition	Row1.equal(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.
Condition	Row10.equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for equality.
Condition	Row11.equal(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for equality.
Condition	Row12.equal(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 equality.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.equal(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for equality.
Condition	Row17.equal(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for equality.
Condition	Row18.equal(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for equality.
Condition	Row19.equal(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.equal(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row20.equal(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for equality.
Condition	Row21.equal(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for equality.
Condition	Row22.equal(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for equality.
Condition	Row3.equal(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for equality.
Condition	Row4.equal(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality.
Condition	Row5.equal(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for equality.
Condition	Row6.equal(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for equality.
Condition	Row7.equal(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for equality.
Condition	Row8.equal(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for equality.
Condition	Row9.equal(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for equality.
SelectOrderByStep<R>	SelectUnionStep.except(Select<? extends R> select) Combine with other selects
Select<R>	Select.except(Select<? extends R> select) Combine with other selects
int	DSLContext.fetchCount(Select<?> query) Execute a Select query in the context of this DSLContext and return a COUNT(*) value.
boolean	DSLContext.fetchExists(Select<?> query) Check if a Select would return any records, if it were executed.
Condition	RowN.ge(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.ge(Select<? extends Record1<T>> query) this >= (Select<?
Condition	Row1.ge(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.ge(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.
Condition	Row12.ge(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.ge(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.ge(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.ge(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.ge(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.ge(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.ge(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.ge(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.ge(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.ge(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.ge(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.ge(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.ge(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.ge(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.ge(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.greaterOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.greaterOrEqual(Select<? extends Record1<T>> query) this >= (Select<?
Condition	Row1.greaterOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.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.
Condition	Row12.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.
Condition	Row13.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.
Condition	Row14.greaterOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Compare this row value expression with a subselect for order.
Condition	Row15.greaterOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect for order.
Condition	Row16.greaterOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for order.
Condition	Row17.greaterOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.greaterOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.greaterOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterOrEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.greaterOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.greaterOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.greaterOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.greaterOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.greaterOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.greaterOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.greaterOrEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.greaterOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.greaterThan(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.greaterThan(Select<? extends Record1<T>> query) this > (Select<?
Condition	Row1.greaterThan(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.greaterThan(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.
Condition	Row12.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.
Condition	Row13.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.
Condition	Row14.greaterThan(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Compare this row value expression with a subselect for order.
Condition	Row15.greaterThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect for order.
Condition	Row16.greaterThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for order.
Condition	Row17.greaterThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.greaterThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.greaterThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.greaterThan(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.greaterThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.greaterThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.greaterThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.greaterThan(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.greaterThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.greaterThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.greaterThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.greaterThan(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.greaterThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.gt(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.gt(Select<? extends Record1<T>> query) this > (Select<?
Condition	Row1.gt(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.gt(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.
Condition	Row12.gt(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.gt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.gt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.gt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.gt(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.gt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.gt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.gt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.gt(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.gt(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.gt(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.gt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.gt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.gt(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.gt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.in(Select<? extends Record> select) Compare this row value expression with a subselect for equality.
Condition	Field.in(Select<? extends Record1<T>> query) Create a condition to check this field against a subquery.
Condition	Row1.in(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.
Condition	Row10.in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for equality.
Condition	Row11.in(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for equality.
Condition	Row12.in(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 equality.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.in(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for equality.
Condition	Row18.in(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for equality.
Condition	Row19.in(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for equality.
Condition	Row2.in(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for equality.
Condition	Row20.in(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for equality.
Condition	Row21.in(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for equality.
Condition	Row22.in(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for equality.
Condition	Row3.in(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for equality.
Condition	Row4.in(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for equality.
Condition	Row5.in(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for equality.
Condition	Row6.in(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for equality.
Condition	Row7.in(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for equality.
Condition	Row8.in(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for equality.
Condition	Row9.in(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for equality.
SelectOrderByStep<R>	SelectUnionStep.intersect(Select<? extends R> select) Combine with other selects
Select<R>	Select.intersect(Select<? extends R> select) Combine with other selects
Condition	RowN.le(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.le(Select<? extends Record1<T>> query) this <= (Select<?
Condition	Row1.le(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.le(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.
Condition	Row12.le(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.le(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.le(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.le(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.le(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.le(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.le(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.le(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.le(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.le(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.le(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.le(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.le(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.le(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.le(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.lessOrEqual(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.lessOrEqual(Select<? extends Record1<T>> query) this <= (Select<?
Condition	Row1.lessOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.lessOrEqual(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.
Condition	Row12.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.
Condition	Row13.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.
Condition	Row14.lessOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Compare this row value expression with a subselect for order.
Condition	Row15.lessOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect for order.
Condition	Row16.lessOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for order.
Condition	Row17.lessOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.lessOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.lessOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessOrEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.lessOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.lessOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.lessOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.lessOrEqual(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.lessOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.lessOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.lessOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.lessOrEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.lessOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.lessThan(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.lessThan(Select<? extends Record1<T>> query) this < (Select<?
Condition	Row1.lessThan(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.lessThan(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.
Condition	Row12.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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.lessThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect for order.
Condition	Row16.lessThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for order.
Condition	Row17.lessThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.lessThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.lessThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lessThan(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.lessThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.lessThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.lessThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.lessThan(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.lessThan(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.lessThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.lessThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.lessThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.lessThan(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.lessThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.lt(Select<? extends Record> select) Compare this row value expression with a subselect for order.
Condition	Field.lt(Select<? extends Record1<T>> query) this < (Select<?
Condition	Row1.lt(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.
Condition	Row10.lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for order.
Condition	Row11.lt(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.
Condition	Row12.lt(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.lt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for order.
Condition	Row18.lt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for order.
Condition	Row19.lt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for order.
Condition	Row2.lt(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for order.
Condition	Row20.lt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for order.
Condition	Row21.lt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for order.
Condition	Row22.lt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for order.
Condition	Row3.lt(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for order.
Condition	Row4.lt(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for order.
Condition	Row5.lt(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for order.
Condition	Row6.lt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for order.
Condition	Row7.lt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for order.
Condition	Row8.lt(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for order.
Condition	Row9.lt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for order.
Condition	RowN.ne(Select<? extends Record> select) Compare this row value expression with a subselect for non-equality.
Condition	Field.ne(Select<? extends Record1<T>> query) this !
Condition	Row1.ne(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row10.ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row11.ne(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row12.ne(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.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.
Condition	Row17.ne(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row18.ne(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row19.ne(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.ne(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row20.ne(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row21.ne(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row22.ne(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row3.ne(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row4.ne(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row5.ne(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row6.ne(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row7.ne(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row8.ne(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row9.ne(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for non-equality.
Condition	RowN.notEqual(Select<? extends Record> select) Compare this row value expression with a subselect for non-equality.
Condition	Field.notEqual(Select<? extends Record1<T>> query) this !
Condition	Row1.notEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row10.notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row11.notEqual(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row12.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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.notEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row16.notEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row17.notEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row18.notEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row19.notEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.notEqual(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row20.notEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row21.notEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row22.notEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row3.notEqual(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row4.notEqual(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row5.notEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row6.notEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row7.notEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row8.notEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row9.notEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for non-equality.
Condition	RowN.notIn(Select<? extends Record> select) Compare this row value expression with a subselect for non-equality.
Condition	Field.notIn(Select<? extends Record1<T>> query) Create a condition to check this field against a subquery.
Condition	Row1.notIn(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row10.notIn(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row11.notIn(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row12.notIn(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.
Condition	Row13.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.
Condition	Row14.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.
Condition	Row15.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.
Condition	Row16.notIn(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row17.notIn(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row18.notIn(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row19.notIn(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row2.notIn(Select<? extends Record2<T1,T2>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row20.notIn(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row21.notIn(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row22.notIn(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row3.notIn(Select<? extends Record3<T1,T2,T3>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row4.notIn(Select<? extends Record4<T1,T2,T3,T4>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row5.notIn(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row6.notIn(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row7.notIn(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row8.notIn(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Compare this row value expression with a subselect for non-equality.
Condition	Row9.notIn(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Compare this row value expression with a subselect for non-equality.
UpdateConditionStep<R>	UpdateConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
TableOnConditionStep	TableOnConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator.
SelectOnConditionStep<R>	SelectOnConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.orExists(Select<?> select) Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
Condition	Condition.orExists(Select<?> select) Combine this condition with an EXISTS clause using the Operator.OR operator.
UpdateConditionStep<R>	UpdateConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator
TableOnConditionStep	TableOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator.
SelectOnConditionStep<R>	SelectOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.orNotExists(Select<?> select) Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator
Condition	Condition.orNotExists(Select<?> select) Combine this condition with a NOT EXIST clause using the Operator.OR operator.
Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result) Add an else clause to the already constructed case statement
Merge<R>	MergeValuesStepN.select(Select<?> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStepN.select(Select<?> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Insert<R>	InsertSetStep.select(Select<?> select) Use a SELECT statement as the source of values for the INSERT statement.
Merge<R>	MergeValuesStep1.select(Select<? extends Record1<T1>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep1.select(Select<? extends Record1<T1>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep12.select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep12.select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep14.select(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep14.select(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep15.select(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep15.select(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep16.select(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep16.select(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep17.select(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep18.select(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	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) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	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) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	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) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	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) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<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 a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep4.select(Select<? extends Record4<T1,T2,T3,T4>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep4.select(Select<? extends Record4<T1,T2,T3,T4>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep7.select(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep7.select(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep8.select(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep8.select(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
Merge<R>	MergeValuesStep9.select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Use a SELECT statement as the source of values for the MERGE statement This variant of the MERGE ..
Insert<R>	InsertValuesStep9.select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
<T> UpdateSetMoreStep<R>	UpdateSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the UPDATE statement.
<T> MergeNotMatchedSetMoreStep<R>	MergeNotMatchedSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set values for INSERT in the MERGE statement's WHEN NOT MATCHED clause.
<T> MergeMatchedSetMoreStep<R>	MergeMatchedSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set values for UPDATE in the MERGE statement's WHEN MATCHED clause.
<T> InsertSetMoreStep<R>	InsertSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	InsertSetMoreStep.set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<T> InsertOnDuplicateSetMoreStep<R>	InsertOnDuplicateSetStep.set(Field<T> field, Select<? extends Record1<T>> value) Set values for UPDATE in the INSERT statement's ON DUPLICATE KEY UPDATE clause.
<T1> UpdateFromStep<R>	UpdateSetFirstStep.set(Row1<T1> row, Select<? extends Record1<T1>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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 the UPDATE statement.
<T1,T2> UpdateFromStep<R>	UpdateSetFirstStep.set(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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 the UPDATE statement.
<T1,T2,T3> UpdateFromStep<R>	UpdateSetFirstStep.set(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4> UpdateFromStep<R>	UpdateSetFirstStep.set(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select) Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8> 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 the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> 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 the UPDATE statement.
SelectOrderByStep<R>	SelectUnionStep.union(Select<? extends R> select) Combine with other selects
Select<R>	Select.union(Select<? extends R> select) Combine with other selects
SelectOrderByStep<R>	SelectUnionStep.unionAll(Select<? extends R> select) Combine with other selects
Select<R>	Select.unionAll(Select<? extends R> select) Combine with other selects
CaseConditionStep<T>	CaseConditionStep.when(Condition condition, Select<? extends Record1<T>> result) Compare a condition to the already constructed case statement, return result if the condition holds true
<T> CaseConditionStep<T>	Case.when(Condition condition, Select<? extends Record1<T>> result) This construct can be used to create expressions of the type CASE WHEN x < 1 THEN 'one' WHEN x >= 2 THEN 'two' ELSE 'three' END
<T> CaseWhenStep<V,T>	CaseValueStep.when(Field<V> compareValue, Select<? extends Record1<T>> result) Compare a value to the already constructed case statement, return result if values are equal.
<T> CaseWhenStep<V,T>	CaseValueStep.when(V compareValue, Select<? extends Record1<T>> result) Compare a value to the already constructed case statement, return result if values are equal.
UpdateConditionStep<R>	UpdateWhereStep.whereExists(Select<?> select) Add an EXISTS clause to the query
SelectConditionStep<R>	SelectWhereStep.whereExists(Select<?> select) Add a WHERE EXISTS clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.whereExists(Select<?> select) Add an EXISTS clause to the query.
UpdateConditionStep<R>	UpdateWhereStep.whereNotExists(Select<?> select) Add a NOT EXISTS clause to the query
SelectConditionStep<R>	SelectWhereStep.whereNotExists(Select<?> select) Add a WHERE NOT EXISTS clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.whereNotExists(Select<?> select) Add a NOT EXISTS clause to the query.

Uses of Select in org.jooq.impl

Methods in org.jooq.impl with parameters of type Select

Modifier and Type	Method and Description
static <R extends Record> QuantifiedSelect<R>	DSL.all(Select<R> select) Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <R extends Record> QuantifiedSelect<R>	DSL.any(Select<R> select) Create an ANY quantified select to be used in quantified comparison predicate expressions.
static Condition	DSL.exists(Select<?> query) Create an exists condition.
int	DefaultDSLContext.fetchCount(Select<?> query)
boolean	DefaultDSLContext.fetchExists(Select<?> query)
static <T> Field<T>	DSL.field(Select<? extends Record1<T>> select) Transform a subquery into a correlated subquery.
static Condition	DSL.notExists(Select<?> query) Create a not exists condition.
static <R extends Record> Table<R>	DSL.table(Select<R> select) A synonym for TableLike.asTable(), which might look a bit more fluent like this, to some users.
static <T> CaseConditionStep<T>	DSL.when(Condition condition, Select<? extends Record1<T>> result) Initialise a Case statement.

Uses of Select in org.jooq.util.postgres

Methods in org.jooq.util.postgres with parameters of type Select

Modifier and Type	Method and Description
static <T> Field<T[]>	PostgresDSL.array(Select<? extends Record1<T>> select) The PostgreSQL array(select) function.