Uses of Interface
org.jooq.Select

Packages that use Select

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

Uses of Select in org.jooq

Subinterfaces of Select in org.jooq

Modifier and Type	Interface	Description
interface	SelectConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByAfterStartWithConditionStep<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	SelectCorrelatedSubqueryStep<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	SelectForJSONCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForStep<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	SelectForXMLCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLPathDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLRawDirectivesStep<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	SelectLimitAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentStep<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	SelectQualifyConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQualifyStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQuery<R extends Record>	A SELECT statement (model API).
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.
interface	SelectWithTiesAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesStep<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	Description
@NotNull Select<R>	Select.except(Select<? extends R> select)	Apply the EXCEPT (or MINUS) set operation.
@NotNull Select<R>	Select.exceptAll(Select<? extends R> select)	Apply the EXCEPT ALL set operation.
@NotNull Select<R>	Select.intersect(Select<? extends R> select)	Apply the INTERSECT set operation.
@NotNull Select<R>	Select.intersectAll(Select<? extends R> select)	Apply the INTERSECT ALL set operation.
@NotNull Select<Record1<T>>	Sequence.nextvals(int size)	An expression to increment the sequence and get the next values.
@NotNull Select<?>	Parser.parseSelect(String sql)	Parse a SQL string to a select statement.
@NotNull Select<?>	Parser.parseSelect(String sql, Object... bindings)	Parse a SQL string to a select statement.
@Nullable Select<?>	TableOptions.select()	The SELECT statement defining this TableOptions.TableType.VIEW or TableOptions.TableType.MATERIALIZED_VIEW.
@NotNull Select<R>	Select.union(Select<? extends R> select)	Apply the UNION set operation.
@NotNull Select<R>	Select.unionAll(Select<? extends R> select)	Apply the UNION ALL set operation.

Methods in org.jooq with parameters of type Select

Modifier and Type	Method	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.
void	UpdateQuery.addValues(RowN row, Select<?> select)	Specify a multi-column set clause for the UPDATE statement.
@NotNull Condition	Condition.andExists(Select<?> select)	Combine this condition with an EXISTS clause using the Operator.AND operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.andExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator
@NotNull Condition	Condition.andNotExists(Select<?> select)	Combine this condition with a NOT EXIST clause using the Operator.AND operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull MergeOnConditionStep<R>	MergeOnConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull SelectConditionStep<R>	SelectConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull SelectHavingConditionStep<R>	SelectHavingConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull SelectOnConditionStep<R>	SelectOnConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.andNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator
@NotNull CreateTableWithDataStep	CreateTableAsStep.as(Select<? extends R> select)	Add an AS clause to the CREATE TABLE statement.
@NotNull CreateViewFinalStep	CreateViewAsStep.as(Select<? extends R> select)	Add an AS clause to the CREATE VIEW statement.
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.as(Select<R> select)	Specify a subselect to refer to by the Name to form a common table expression.
@NotNull WithStep	WithAsStep.as(Select<?> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep1.as(Select<? extends Record1<?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep10.as(Select<? extends Record10<?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep11.as(Select<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep12.as(Select<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep13.as(Select<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep14.as(Select<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep15.as(Select<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep16.as(Select<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep17.as(Select<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep18.as(Select<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep19.as(Select<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep2.as(Select<? extends Record2<?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep20.as(Select<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep21.as(Select<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep22.as(Select<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep3.as(Select<? extends Record3<?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep4.as(Select<? extends Record4<?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep5.as(Select<? extends Record5<?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep6.as(Select<? extends Record6<?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep7.as(Select<? extends Record7<?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep8.as(Select<? extends Record8<?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep9.as(Select<? extends Record9<?,?,?,?,?,?,?,?,?>> select)	Associate a subselect with a common table expression's table and column names.
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.asMaterialized(Select<R> select)	Specify a materialized subselect to refer to by the Name to form a common table expression.
@NotNull WithStep	WithAsStep.asMaterialized(Select<?> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep1.asMaterialized(Select<? extends Record1<?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep10.asMaterialized(Select<? extends Record10<?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep11.asMaterialized(Select<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep12.asMaterialized(Select<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep13.asMaterialized(Select<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep14.asMaterialized(Select<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep15.asMaterialized(Select<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep16.asMaterialized(Select<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep17.asMaterialized(Select<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep18.asMaterialized(Select<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep19.asMaterialized(Select<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep2.asMaterialized(Select<? extends Record2<?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep20.asMaterialized(Select<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep21.asMaterialized(Select<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep22.asMaterialized(Select<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep3.asMaterialized(Select<? extends Record3<?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep4.asMaterialized(Select<? extends Record4<?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep5.asMaterialized(Select<? extends Record5<?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep6.asMaterialized(Select<? extends Record6<?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep7.asMaterialized(Select<? extends Record7<?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep8.asMaterialized(Select<? extends Record8<?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep9.asMaterialized(Select<? extends Record9<?,?,?,?,?,?,?,?,?>> select)	Associate a materialized subselect with a common table expression's table and column names.
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?,?,?,?,?,?,?,?,?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.asNotMaterialized(Select<R> select)	Specify a non-materialized subselect to refer to by the Name to form a common table expression.
@NotNull WithStep	WithAsStep.asNotMaterialized(Select<?> select)	Associate a materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep1.asNotMaterialized(Select<? extends Record1<?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep10.asNotMaterialized(Select<? extends Record10<?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep11.asNotMaterialized(Select<? extends Record11<?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep12.asNotMaterialized(Select<? extends Record12<?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep13.asNotMaterialized(Select<? extends Record13<?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep14.asNotMaterialized(Select<? extends Record14<?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep15.asNotMaterialized(Select<? extends Record15<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep16.asNotMaterialized(Select<? extends Record16<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep17.asNotMaterialized(Select<? extends Record17<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep18.asNotMaterialized(Select<? extends Record18<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep19.asNotMaterialized(Select<? extends Record19<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep2.asNotMaterialized(Select<? extends Record2<?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep20.asNotMaterialized(Select<? extends Record20<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep21.asNotMaterialized(Select<? extends Record21<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep22.asNotMaterialized(Select<? extends Record22<?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep3.asNotMaterialized(Select<? extends Record3<?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep4.asNotMaterialized(Select<? extends Record4<?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep5.asNotMaterialized(Select<? extends Record5<?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep6.asNotMaterialized(Select<? extends Record6<?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep7.asNotMaterialized(Select<? extends Record7<?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep8.asNotMaterialized(Select<? extends Record8<?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull WithStep	WithAsStep9.asNotMaterialized(Select<? extends Record9<?,?,?,?,?,?,?,?,?>> select)	Associate a non-materialized subselect with a common table expression's table and column names.
@NotNull BetweenAndStep<R>	SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue)	Check if this subquery is within a range of two subqueries.
@NotNull Condition	SelectCorrelatedSubqueryStep.between(Select<? extends R> minValue, Select<? extends R> maxValue)	Check if this subquery is within a range of two subqueries.
@NotNull BetweenAndStepR<R>	SelectCorrelatedSubqueryStep.betweenSymmetric(Select<? extends R> minValue)	Check if this subquery is within a symmetric range of two subqueries.
@NotNull Condition	SelectCorrelatedSubqueryStep.betweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue)	Check if this subquery is within a symmetric range of two subqueries.
@NotNull Condition	Field.compare(Comparator comparator, Select<? extends Record1<T>> query)	Compare this field with a subselect using a dynamic comparator.
@NotNull Condition	Row1.compare(Comparator comparator, Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row10.compare(Comparator comparator, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row11.compare(Comparator comparator, Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row12.compare(Comparator comparator, Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row13.compare(Comparator comparator, Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row14.compare(Comparator comparator, Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row15.compare(Comparator comparator, Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row16.compare(Comparator comparator, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row17.compare(Comparator comparator, Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row18.compare(Comparator comparator, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row19.compare(Comparator comparator, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row2.compare(Comparator comparator, Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row20.compare(Comparator comparator, Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row21.compare(Comparator comparator, Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row22.compare(Comparator comparator, Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	Row3.compare(Comparator comparator, Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.compare(Comparator comparator, Select<? extends Record> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	SelectCorrelatedSubqueryStep.compare(Comparator comparator, Select<? extends R> select)	Compare this subquery with a subquery using a dynamic comparator.
@NotNull Field<T>	CaseConditionStep.else_(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull Condition	Field.eq(Select<? extends Record1<T>> query)	this = (Select<?> ...).
@NotNull Condition	Row1.eq(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.eq(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row18.eq(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row19.eq(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row2.eq(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row20.eq(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row21.eq(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row22.eq(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row3.eq(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row4.eq(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.eq(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row6.eq(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row7.eq(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.eq(Select<? extends Record> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.eq(Select<? extends R> select)	Compare this subquery with another record for equality.
@NotNull Condition	Field.equal(Select<? extends Record1<T>> query)	this = (Select<?> ...).
@NotNull Condition	Row1.equal(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row16.equal(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row17.equal(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row18.equal(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row19.equal(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row2.equal(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row20.equal(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row21.equal(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row22.equal(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row3.equal(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row4.equal(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.equal(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row6.equal(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row7.equal(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.equal(Select<? extends Record> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.equal(Select<? extends R> select)	Compare this subquery with another record for equality.
@NotNull Select<R>	Select.except(Select<? extends R> select)	Apply the EXCEPT (or MINUS) set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.except(Select<? extends R> select)	Apply the EXCEPT (or MINUS) set operation.
@NotNull Select<R>	Select.exceptAll(Select<? extends R> select)	Apply the EXCEPT ALL set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.exceptAll(Select<? extends R> select)	Apply the EXCEPT ALL set operation.
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.
@NotNull Condition	Field.ge(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
@NotNull Condition	Row1.ge(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.ge(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.ge(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.ge(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.ge(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.ge(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.ge(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.ge(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.ge(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.ge(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.ge(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.ge(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.ge(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.ge(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.ge(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.greaterOrEqual(Select<? extends Record1<T>> query)	this >= (Select<?> ...).
@NotNull Condition	Row1.greaterOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row14.greaterOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row15.greaterOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row16.greaterOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row17.greaterOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.greaterOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.greaterOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.greaterOrEqual(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.greaterOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.greaterOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.greaterOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.greaterOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.greaterOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.greaterOrEqual(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.greaterOrEqual(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.greaterThan(Select<? extends Record1<T>> query)	this > (Select<?> ...).
@NotNull Condition	Row1.greaterThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row14.greaterThan(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row15.greaterThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row16.greaterThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row17.greaterThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.greaterThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.greaterThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.greaterThan(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.greaterThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.greaterThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.greaterThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.greaterThan(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.greaterThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.greaterThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.greaterThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.greaterThan(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.greaterThan(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.gt(Select<? extends Record1<T>> query)	this > (Select<?> ...).
@NotNull Condition	Row1.gt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.gt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.gt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.gt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.gt(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.gt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.gt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.gt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.gt(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.gt(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.gt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.gt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.gt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.gt(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.gt(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.in(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
@NotNull Condition	Row1.in(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.in(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row18.in(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row19.in(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row2.in(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row20.in(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row21.in(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row22.in(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row3.in(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row4.in(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row5.in(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row6.in(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	Row7.in(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for equality.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.in(Select<? extends Record> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.in(Select<? extends R> select)	Compare this subquery with another subquery for equality.
@NotNull Select<R>	Select.intersect(Select<? extends R> select)	Apply the INTERSECT set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.intersect(Select<? extends R> select)	Apply the INTERSECT set operation.
@NotNull Select<R>	Select.intersectAll(Select<? extends R> select)	Apply the INTERSECT ALL set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.intersectAll(Select<? extends R> select)	Apply the INTERSECT ALL set operation.
@NotNull Condition	Field.isDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is DISTINCT from another field.
@NotNull Condition	Row1.isDistinctFrom(Select<? extends Record1<T1>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row10.isDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row11.isDistinctFrom(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row12.isDistinctFrom(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row13.isDistinctFrom(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row14.isDistinctFrom(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row15.isDistinctFrom(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row16.isDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row17.isDistinctFrom(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row18.isDistinctFrom(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row19.isDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row2.isDistinctFrom(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row20.isDistinctFrom(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row21.isDistinctFrom(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row22.isDistinctFrom(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row3.isDistinctFrom(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row4.isDistinctFrom(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.isDistinctFrom(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row6.isDistinctFrom(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row7.isDistinctFrom(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row8.isDistinctFrom(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row9.isDistinctFrom(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	RowN.isDistinctFrom(Select<? extends Record> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	SelectCorrelatedSubqueryStep.isDistinctFrom(Select<? extends R> select)	Compare this subquery with another record for distinctness.
@NotNull Condition	Field.isNotDistinctFrom(Select<? extends Record1<T>> select)	Create a condition to check if this field is NOT DISTINCT from another field.
@NotNull Condition	Row1.isNotDistinctFrom(Select<? extends Record1<T1>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row10.isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row11.isNotDistinctFrom(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row12.isNotDistinctFrom(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row13.isNotDistinctFrom(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row14.isNotDistinctFrom(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row15.isNotDistinctFrom(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row16.isNotDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row17.isNotDistinctFrom(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row18.isNotDistinctFrom(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row19.isNotDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row2.isNotDistinctFrom(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row20.isNotDistinctFrom(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row21.isNotDistinctFrom(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row22.isNotDistinctFrom(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row3.isNotDistinctFrom(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row4.isNotDistinctFrom(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row5.isNotDistinctFrom(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row6.isNotDistinctFrom(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row7.isNotDistinctFrom(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row8.isNotDistinctFrom(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	Row9.isNotDistinctFrom(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	RowN.isNotDistinctFrom(Select<? extends Record> select)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	SelectCorrelatedSubqueryStep.isNotDistinctFrom(Select<? extends R> select)	Compare this subquery with another record for distinctness.
@NotNull Condition	Field.le(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
@NotNull Condition	Row1.le(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.le(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.le(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.le(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.le(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.le(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.le(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.le(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.le(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.le(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.le(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.le(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.le(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.le(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.le(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.lessOrEqual(Select<? extends Record1<T>> query)	this <= (Select<?> ...).
@NotNull Condition	Row1.lessOrEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row14.lessOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row15.lessOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row16.lessOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row17.lessOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.lessOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.lessOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.lessOrEqual(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.lessOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.lessOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.lessOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.lessOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.lessOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.lessOrEqual(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.lessOrEqual(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.lessThan(Select<? extends Record1<T>> query)	this < (Select<?> ...).
@NotNull Condition	Row1.lessThan(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row15.lessThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row16.lessThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row17.lessThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.lessThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.lessThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.lessThan(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.lessThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.lessThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.lessThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.lessThan(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.lessThan(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lessThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.lessThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.lessThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.lessThan(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.lessThan(Select<? extends R> select)	Compare this subquery with another record for order.
@NotNull Condition	Field.lt(Select<? extends Record1<T>> query)	this < (Select<?> ...).
@NotNull Condition	Row1.lt(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.lt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row18.lt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row19.lt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row2.lt(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row20.lt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row21.lt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row22.lt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row3.lt(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row4.lt(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row5.lt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row6.lt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	Row7.lt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Compare this row value expression with a subselect for order.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.lt(Select<? extends Record> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	SelectCorrelatedSubqueryStep.lt(Select<? extends R> select)	Compare this subquery with another record for order.
static @NotNull TableOptions	TableOptions.materializedView(Select<?> select)	Create a new TableOptions object for a TableOptions.TableType.MATERIALIZED_VIEW.
@NotNull Condition	Field.ne(Select<? extends Record1<T>> query)	this != (Select<?> ...).
@NotNull Condition	Row1.ne(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row17.ne(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row18.ne(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row19.ne(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row2.ne(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row20.ne(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row21.ne(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row22.ne(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row3.ne(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row4.ne(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.ne(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row6.ne(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.ne(Select<? extends Record> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.ne(Select<? extends R> select)	Compare this subquery with another record for non-equality.
@NotNull BetweenAndStepR<R>	SelectCorrelatedSubqueryStep.notBetween(Select<? extends R> minValue)	Check if this subquery is not within a range of two subqueries.
@NotNull Condition	SelectCorrelatedSubqueryStep.notBetween(Select<? extends R> minValue, Select<? extends R> maxValue)	Check if this subquery is not within a range of two subqueries.
@NotNull BetweenAndStepR<R>	SelectCorrelatedSubqueryStep.notBetweenSymmetric(Select<? extends R> minValue)	Check if this subquery is not within a symmetric range of two subqueries.
@NotNull Condition	SelectCorrelatedSubqueryStep.notBetweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue)	Check if this subquery is not within a symmetric range of two subqueries.
@NotNull Condition	Field.notEqual(Select<? extends Record1<T>> query)	this != (Select<?> ...).
@NotNull Condition	Row1.notEqual(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row15.notEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row16.notEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row17.notEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row18.notEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row19.notEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row2.notEqual(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row20.notEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row21.notEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row22.notEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row3.notEqual(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row4.notEqual(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.notEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row6.notEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.notEqual(Select<? extends Record> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.notEqual(Select<? extends R> select)	Compare this subquery with another record for non-equality.
@NotNull Condition	Field.notIn(Select<? extends Record1<T>> query)	Create a condition to check this field against a subquery.
@NotNull Condition	Row1.notIn(Select<? extends Record1<T1>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	Row16.notIn(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row17.notIn(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row18.notIn(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row19.notIn(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row2.notIn(Select<? extends Record2<T1,T2>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row20.notIn(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row21.notIn(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row22.notIn(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row3.notIn(Select<? extends Record3<T1,T2,T3>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row4.notIn(Select<? extends Record4<T1,T2,T3,T4>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row5.notIn(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	Row6.notIn(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull Condition	RowN.notIn(Select<? extends Record> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	SelectCorrelatedSubqueryStep.notIn(Select<? extends R> select)	Compare this subquery with another subquery for non-equality.
@NotNull Condition	Condition.orExists(Select<?> select)	Combine this condition with an EXISTS clause using the Operator.OR operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull 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.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.orExists(Select<?> select)	Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator
@NotNull Condition	Condition.orNotExists(Select<?> select)	Combine this condition with a NOT EXIST clause using the Operator.OR operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull MergeOnConditionStep<R>	MergeOnConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull SelectConditionStep<R>	SelectConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull SelectHavingConditionStep<R>	SelectHavingConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull SelectOnConditionStep<R>	SelectOnConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.orNotExists(Select<?> select)	Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator
@NotNull Field<T>	CaseConditionStep.otherwise(Select<? extends Record1<T>> result)	Add an else clause to the already constructed case statement
@NotNull InsertOnDuplicateStep<R>	InsertSetStep.select(Select<?> select)	Use a SELECT statement as the source of values for the INSERT statement.
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep1.select(Select<? extends Record1<T1>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep15.select(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep16.select(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep17.select(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep18.select(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep19.select(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep20.select(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep21.select(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep22.select(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<R>	InsertValuesStep4.select(Select<? extends Record4<T1,T2,T3,T4>> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<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
@NotNull InsertOnDuplicateStep<R>	InsertValuesStepN.select(Select<?> select)	Use a SELECT statement as the source of values for the INSERT statement
@NotNull Merge<R>	MergeValuesStep1.select(Select<? extends Record1<T1>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep12.select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep14.select(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep15.select(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep16.select(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull 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)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep4.select(Select<? extends Record4<T1,T2,T3,T4>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep7.select(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep8.select(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStep9.select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)	Deprecated. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull Merge<R>	MergeValuesStepN.select(Select<?> select)	Use a SELECT statement as the source of values for the MERGE statement
@NotNull Statement	Declaration.set(Select<? extends Record1<T>> value)	Initialise this declaration.
<T> @NotNull 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 or ON CONFLICT ...
<T> @NotNull InsertSetMoreStep<R>	InsertSetMoreStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> @NotNull InsertSetMoreStep<R>	InsertSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the INSERT statement.
<T> @NotNull 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> @NotNull 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.
<T1> @NotNull 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> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row, Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row, Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row, Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row, Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row, Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row, Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2> @NotNull 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> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row, Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row, Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)	Specify a multi-column set clause for 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> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row, Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3> @NotNull 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> @NotNull 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> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row5<T1,T2,T3,T4,T5> row, Select<? extends Record5<T1,T2,T3,T4,T5>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row6<T1,T2,T3,T4,T5,T6> row, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row7<T1,T2,T3,T4,T5,T6,T7> row, Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row, Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)	Specify a multi-column set clause for the UPDATE statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> @NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row, Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)	Specify a multi-column set clause for the UPDATE statement.
@NotNull UpdateFromStep<R>	UpdateSetFirstStep.set(RowN row, Select<?> select)	Specify a multi-column set clause for the UPDATE statement.
<T> @NotNull UpdateSetMoreStep<R>	UpdateSetStep.set(Field<T> field, Select<? extends Record1<T>> value)	Set a value for a field in the UPDATE statement.
@NotNull Statement	Variable.set(Select<? extends Record1<T>> value)	Assign a value to this variable.
void	InsertQuery.setSelect(Collection<? extends Field<?>> fields, Select<?> select)	Use a SELECT statement as the source of values for the INSERT statement.
void	InsertQuery.setSelect(Field<?>[] fields, Select<?> select)	Use a SELECT statement as the source of values for the INSERT statement.
@NotNull Select<R>	Select.union(Select<? extends R> select)	Apply the UNION set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.union(Select<? extends R> select)	Apply the UNION set operation.
@NotNull Select<R>	Select.unionAll(Select<? extends R> select)	Apply the UNION ALL set operation.
@NotNull SelectOrderByStep<R>	SelectUnionStep.unionAll(Select<? extends R> select)	Apply the UNION ALL set operation.
<T> @NotNull JSONEntry<T>	JSONEntryValueStep.value(Select<? extends Record1<T>> value)	The JSON entry value.
static @NotNull TableOptions	TableOptions.view(Select<?> select)	Create a new TableOptions object for a TableOptions.TableType.VIEW.
<T> @NotNull CaseConditionStep<T>	Case.when(Condition condition, Select<? extends Record1<T>> result)	This construct can be used to create expressions of the type
<T> @NotNull CaseConditionStep<T>	Case.when(Field<Boolean> condition, Select<? extends Record1<T>> result)	This construct can be used to create expressions of the type
@NotNull 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
@NotNull CaseConditionStep<T>	CaseConditionStep.when(Field<Boolean> condition, Select<? extends Record1<T>> result)	Compare a condition to the already constructed case statement, return result if the condition holds true
<T> @NotNull 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> @NotNull 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.
@NotNull DeleteConditionStep<R>	DeleteWhereStep.whereExists(Select<?> select)	Add an EXISTS clause to the query.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictWhereStep.whereExists(Select<?> select)	Add a WHERE EXISTS clause to the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT ...
@NotNull SelectConditionStep<R>	SelectWhereStep.whereExists(Select<?> select)	Add a WHERE EXISTS clause to the query.
@NotNull Table<R>	Table.whereExists(Select<?> select)	Add a WHERE EXISTS clause to the table.
@NotNull UpdateConditionStep<R>	UpdateWhereStep.whereExists(Select<?> select)	Add an EXISTS clause to the query
@NotNull DeleteConditionStep<R>	DeleteWhereStep.whereNotExists(Select<?> select)	Add a NOT EXISTS clause to the query.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictWhereStep.whereNotExists(Select<?> select)	Add a WHERE NOT EXISTS clause to the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT ...
@NotNull SelectConditionStep<R>	SelectWhereStep.whereNotExists(Select<?> select)	Add a WHERE NOT EXISTS clause to the query.
@NotNull Table<R>	Table.whereNotExists(Select<?> select)	Add a WHERE NOT EXISTS clause to the table.
@NotNull UpdateConditionStep<R>	UpdateWhereStep.whereNotExists(Select<?> select)	Add a NOT EXISTS clause to the query

Uses of Select in org.jooq.impl

Methods in org.jooq.impl that return Select

Modifier and Type	Method	Description
Select<Record1<T>>	SequenceImpl.nextvals(int size)

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

Modifier and Type	Method	Description
static <R extends Record> @NotNull QuantifiedSelect<R>	DSL.all(Select<R> select)	Create an ALL quantified select to be used in quantified comparison predicate expressions.
static <R extends Record> @NotNull QuantifiedSelect<R>	DSL.any(Select<R> select)	Create an ANY quantified select to be used in quantified comparison predicate expressions.
static @NotNull Condition	DSL.exists(Select<?> query)	Create an exists condition.
int	DefaultDSLContext.fetchCount(Select<?> query)
boolean	DefaultDSLContext.fetchExists(Select<?> query)
static <T> @NotNull Field<T>	DSL.field(Select<? extends Record1<T>> select)	Transform a subquery into a correlated subquery.
static @NotNull Condition	DSL.notExists(Select<?> query)	Create a not exists condition.
static @NotNull Condition	DSL.notUnique(Select<?> query)	Create a not unique condition.
static <R extends Record> @NotNull 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 @NotNull Condition	DSL.unique(Select<?> query)	Create a unique condition.
static <T> @NotNull CaseConditionStep<T>	DSL.when(Condition condition, Select<? extends Record1<T>> result)	Initialise a Case statement.
static <T> @NotNull CaseConditionStep<T>	DSL.when(Field<Boolean> 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	Description
static <T> @NotNull Field<T[]>	PostgresDSL.array(Select<? extends Record1<T>> select)	The PostgreSQL array(select) function.