Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
org.jooq.util.postgres |
The
org.jooq.util.ase package contains classes related to the
SQLDialect.POSTGRES dialect. |
Modifier and Type | Interface and Description |
---|---|
interface |
SelectConditionStep<R extends Record>
|
interface |
SelectConnectByConditionStep<R extends Record>
|
interface |
SelectConnectByStep<R extends Record>
|
interface |
SelectDistinctOnStep<R extends Record>
|
interface |
SelectFinalStep<R extends Record>
|
interface |
SelectForUpdateOfStep<R extends Record>
|
interface |
SelectForUpdateStep<R extends Record>
|
interface |
SelectForUpdateWaitStep<R extends Record>
|
interface |
SelectFromStep<R extends Record>
|
interface |
SelectGroupByStep<R extends Record>
|
interface |
SelectHavingConditionStep<R extends Record>
|
interface |
SelectHavingStep<R extends Record>
|
interface |
SelectIntoStep<R extends Record>
|
interface |
SelectJoinStep<R extends Record>
|
interface |
SelectLimitStep<R extends Record>
|
interface |
SelectOffsetStep<R extends Record>
|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
interface |
SelectOptionStep<R extends Record>
|
interface |
SelectOrderByStep<R extends Record>
|
interface |
SelectQuery<R extends Record>
A query for data selection
|
interface |
SelectSeekLimitStep<R extends Record>
|
interface |
SelectSeekStep1<R extends Record,T1>
|
interface |
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
|
interface |
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
|
interface |
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
|
interface |
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
|
interface |
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
|
interface |
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
|
interface |
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
|
interface |
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
|
interface |
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
|
interface |
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
|
interface |
SelectSeekStep2<R extends Record,T1,T2>
|
interface |
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
|
interface |
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
|
interface |
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
|
interface |
SelectSeekStep3<R extends Record,T1,T2,T3>
|
interface |
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
|
interface |
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
|
interface |
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
|
interface |
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
|
interface |
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
|
interface |
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
|
interface |
SelectSeekStepN<R extends Record>
|
interface |
SelectSelectStep<R extends Record>
|
interface |
SelectStartWithStep<R extends Record>
|
interface |
SelectUnionStep<R extends Record>
|
interface |
SelectWhereStep<R extends Record>
|
interface |
SelectWindowStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
Select<R> |
Select.except(Select<? extends R> select)
Apply the
EXCEPT (or MINUS ) set operation. |
Select<R> |
Select.exceptAll(Select<? extends R> select)
Apply the
EXCEPT ALL set operation. |
Select<R> |
Select.intersect(Select<? extends R> select)
Apply the
INTERSECT set operation. |
Select<R> |
Select.intersectAll(Select<? extends R> select)
Apply the
INTERSECT ALL set operation. |
Select<R> |
Select.union(Select<? extends R> select)
Apply the
UNION set operation. |
Select<R> |
Select.unionAll(Select<? extends R> select)
Apply the
UNION ALL set operation. |
Modifier and Type | Method and Description |
---|---|
<T1> void |
UpdateQuery.addValues(Row1<T1> row,
Select<? extends Record1<T1>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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. |
UpdateConditionStep<R> |
UpdateConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator |
TableOnConditionStep<R> |
TableOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator |
Condition |
Condition.andExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.AND operator. |
UpdateConditionStep<R> |
UpdateConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator |
TableOnConditionStep<R> |
TableOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator |
Condition |
Condition.andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.AND operator. |
WithStep |
WithAsStep.as(Select<?> select)
Associate a subselect with a common table expression's table and column names.
|
CreateViewFinalStep |
CreateViewAsStep.as(Select<? extends R> select)
Add an
AS clause to the CREATE VIEW statement. |
CreateTableOnCommitStep |
CreateTableAsStep.as(Select<? extends R> select)
Add an
AS clause to the CREATE TABLE statement. |
<R extends Record> |
Name.as(Select<R> select)
Specify a subselect to refer to by the
Name to form a common
table expression. |
<R extends Record> |
DerivedColumnList.as(Select<R> select)
Specify a subselect to refer to by the
DerivedColumnList to
form a common table expression. |
Condition |
RowN.compare(Comparator comparator,
Select<? extends Record> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Field.compare(Comparator comparator,
Select<? extends Record1<T>> query)
Compare this field with a subselect using a dynamic comparator.
|
Condition |
Row1.compare(Comparator comparator,
Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row10.compare(Comparator comparator,
Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row11.compare(Comparator comparator,
Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row12.compare(Comparator comparator,
Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row13.compare(Comparator comparator,
Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row14.compare(Comparator comparator,
Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row15.compare(Comparator comparator,
Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row16.compare(Comparator comparator,
Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row17.compare(Comparator comparator,
Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row18.compare(Comparator comparator,
Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row19.compare(Comparator comparator,
Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row2.compare(Comparator comparator,
Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row20.compare(Comparator comparator,
Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row21.compare(Comparator comparator,
Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row22.compare(Comparator comparator,
Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row3.compare(Comparator comparator,
Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row4.compare(Comparator comparator,
Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row5.compare(Comparator comparator,
Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row6.compare(Comparator comparator,
Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row7.compare(Comparator comparator,
Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row8.compare(Comparator comparator,
Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
Row9.compare(Comparator comparator,
Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
RowN.eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.eq(Select<? extends Record1<T>> query)
this = (Select<? |
Condition |
Row1.eq(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row10.eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row11.eq(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row12.eq(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.eq(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row14.eq(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row15.eq(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row16.eq(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row17.eq(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row18.eq(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row19.eq(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.eq(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row20.eq(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row21.eq(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row22.eq(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.eq(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row4.eq(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row5.eq(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row6.eq(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row7.eq(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row8.eq(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row9.eq(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
RowN.equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.equal(Select<? extends Record1<T>> query)
this = (Select<? |
Condition |
Row1.equal(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row10.equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row11.equal(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row12.equal(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.equal(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row14.equal(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row15.equal(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row16.equal(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row17.equal(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row18.equal(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row19.equal(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.equal(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row20.equal(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row21.equal(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row22.equal(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.equal(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row4.equal(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row5.equal(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row6.equal(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row7.equal(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row8.equal(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row9.equal(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.
|
SelectOrderByStep<R> |
SelectUnionStep.except(Select<? extends R> select)
Apply the
EXCEPT (or MINUS ) set operation. |
Select<R> |
Select.except(Select<? extends R> select)
Apply the
EXCEPT (or MINUS ) set operation. |
SelectOrderByStep<R> |
SelectUnionStep.exceptAll(Select<? extends R> select)
Apply the
EXCEPT ALL set operation. |
Select<R> |
Select.exceptAll(Select<? extends R> select)
Apply the
EXCEPT ALL set operation. |
int |
DSLContext.fetchCount(Select<?> query)
|
boolean |
DSLContext.fetchExists(Select<?> query)
Check if a
Select would return any records, if it were executed. |
Condition |
RowN.ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.ge(Select<? extends Record1<T>> query)
this >= (Select<? |
Condition |
Row1.ge(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.ge(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.ge(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.ge(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.ge(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.ge(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.ge(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.ge(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.ge(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.ge(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.ge(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.ge(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.ge(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.ge(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.ge(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.ge(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.ge(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.ge(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.ge(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.ge(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.ge(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterOrEqual(Select<? extends Record1<T>> query)
this >= (Select<? |
Condition |
Row1.greaterOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.greaterOrEqual(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.greaterOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.greaterOrEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.greaterOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.greaterOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.greaterOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.greaterOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.greaterOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.greaterOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.greaterOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.greaterOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.greaterOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.greaterOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.greaterOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.greaterOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.greaterOrEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.greaterOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.greaterThan(Select<? extends Record1<T>> query)
this > (Select<? |
Condition |
Row1.greaterThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.greaterThan(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.greaterThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.greaterThan(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.greaterThan(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.greaterThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.greaterThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.greaterThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.greaterThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.greaterThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.greaterThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.greaterThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.greaterThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.greaterThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.greaterThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.greaterThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.greaterThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.greaterThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.greaterThan(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.greaterThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.gt(Select<? extends Record1<T>> query)
this > (Select<? |
Condition |
Row1.gt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.gt(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.gt(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.gt(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.gt(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.gt(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.gt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.gt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.gt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.gt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.gt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.gt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.gt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.gt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.gt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.gt(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.gt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.gt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.gt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.gt(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.gt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Field.in(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Row1.in(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row10.in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row11.in(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row12.in(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row13.in(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row14.in(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row15.in(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row16.in(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row17.in(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row18.in(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row19.in(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row2.in(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row20.in(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row21.in(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row22.in(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row3.in(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row4.in(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row5.in(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row6.in(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row7.in(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row8.in(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
Row9.in(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.
|
SelectOrderByStep<R> |
SelectUnionStep.intersect(Select<? extends R> select)
Apply the
INTERSECT set operation. |
Select<R> |
Select.intersect(Select<? extends R> select)
Apply the
INTERSECT set operation. |
SelectOrderByStep<R> |
SelectUnionStep.intersectAll(Select<? extends R> select)
Apply the
INTERSECT ALL set operation. |
Select<R> |
Select.intersectAll(Select<? extends R> select)
Apply the
INTERSECT ALL set operation. |
Condition |
RowN.le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.le(Select<? extends Record1<T>> query)
this <= (Select<? |
Condition |
Row1.le(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.le(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.le(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.le(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.le(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.le(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.le(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.le(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.le(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.le(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.le(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.le(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.le(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.le(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.le(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.le(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.le(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.le(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.le(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.le(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.le(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessOrEqual(Select<? extends Record1<T>> query)
this <= (Select<? |
Condition |
Row1.lessOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.lessOrEqual(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.lessOrEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lessOrEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.lessOrEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.lessOrEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.lessOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.lessOrEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.lessOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.lessOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.lessOrEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.lessOrEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.lessOrEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.lessOrEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.lessOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.lessOrEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.lessOrEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.lessOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lessThan(Select<? extends Record1<T>> query)
this < (Select<? |
Condition |
Row1.lessThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.lessThan(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.lessThan(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lessThan(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.lessThan(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.lessThan(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.lessThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.lessThan(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.lessThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.lessThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lessThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.lessThan(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.lessThan(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.lessThan(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lessThan(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.lessThan(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.lessThan(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.lessThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.lessThan(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.lessThan(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.lessThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.
|
Condition |
Field.lt(Select<? extends Record1<T>> query)
this < (Select<? |
Condition |
Row1.lt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row10.lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row11.lt(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row12.lt(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row13.lt(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row14.lt(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row15.lt(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row16.lt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row17.lt(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row18.lt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row19.lt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row2.lt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row20.lt(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row21.lt(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row22.lt(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row3.lt(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row4.lt(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row5.lt(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row6.lt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row7.lt(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row8.lt(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for order.
|
Condition |
Row9.lt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.
|
Condition |
RowN.ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.ne(Select<? extends Record1<T>> query)
this ! |
Condition |
Row1.ne(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row10.ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row11.ne(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row12.ne(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row13.ne(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row14.ne(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row15.ne(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row16.ne(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row17.ne(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row18.ne(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row19.ne(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.ne(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row20.ne(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row21.ne(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row22.ne(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.ne(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row4.ne(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row5.ne(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row6.ne(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row7.ne(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row8.ne(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row9.ne(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.notEqual(Select<? extends Record1<T>> query)
this ! |
Condition |
Row1.notEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row10.notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row11.notEqual(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row12.notEqual(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row13.notEqual(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row14.notEqual(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row15.notEqual(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row16.notEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row17.notEqual(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row18.notEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row19.notEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.notEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row20.notEqual(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row21.notEqual(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row22.notEqual(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.notEqual(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row4.notEqual(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row5.notEqual(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row6.notEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row7.notEqual(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row8.notEqual(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row9.notEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
RowN.notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Field.notIn(Select<? extends Record1<T>> query)
Create a condition to check this field against a subquery.
|
Condition |
Row1.notIn(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row10.notIn(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row11.notIn(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row12.notIn(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row13.notIn(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row14.notIn(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row15.notIn(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row16.notIn(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row17.notIn(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row18.notIn(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row19.notIn(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row2.notIn(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row20.notIn(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row21.notIn(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row22.notIn(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row3.notIn(Select<? extends Record3<T1,T2,T3>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row4.notIn(Select<? extends Record4<T1,T2,T3,T4>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row5.notIn(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row6.notIn(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row7.notIn(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row8.notIn(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
Row9.notIn(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.
|
UpdateConditionStep<R> |
UpdateConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator |
TableOnConditionStep<R> |
TableOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator |
Condition |
Condition.orExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.OR operator. |
UpdateConditionStep<R> |
UpdateConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator |
TableOnConditionStep<R> |
TableOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator. |
SelectOnConditionStep<R> |
SelectOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep<R> |
SelectHavingConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectConditionStep<R> |
SelectConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator |
Condition |
Condition.orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.OR operator. |
Field<T> |
CaseConditionStep.otherwise(Select<? extends Record1<T>> result)
Add an else clause to the already constructed case statement
|
Merge<R> |
MergeValuesStepN.select(Select<?> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
Insert<R> |
InsertValuesStepN.select(Select<?> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
InsertReturningStep<R> |
InsertSetStep.select(Select<?> select)
Use a
SELECT statement as the source of values for the
INSERT statement. |
Merge<R> |
MergeValuesStep1.select(Select<? extends Record1<T1>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
InsertOnDuplicateStep<R> |
InsertValuesStep1.select(Select<? extends Record1<T1>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep10.select(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep11.select(Select<? extends Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep12.select(Select<? extends Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep13.select(Select<? extends Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep14.select(Select<? extends Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep15.select(Select<? extends Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep16.select(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep17.select(Select<? extends Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep18.select(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep19.select(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep2.select(Select<? extends Record2<T1,T2>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
InsertOnDuplicateStep<R> |
InsertValuesStep2.select(Select<? extends Record2<T1,T2>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep20.select(Select<? extends Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep21.select(Select<? extends Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep22.select(Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
InsertOnDuplicateStep<R> |
InsertValuesStep3.select(Select<? extends Record3<T1,T2,T3>> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep4.select(Select<? extends Record4<T1,T2,T3,T4>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep5.select(Select<? extends Record5<T1,T2,T3,T4,T5>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep7.select(Select<? extends Record7<T1,T2,T3,T4,T5,T6,T7>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep8.select(Select<? extends Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
Merge<R> |
MergeValuesStep9.select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
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
This variant of the INSERT .. |
<T> UpdateSetMoreStep<R> |
UpdateSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
UPDATE statement. |
<T> MergeNotMatchedSetMoreStep<R> |
MergeNotMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause. |
<T> MergeMatchedSetMoreStep<R> |
MergeMatchedSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause. |
<T> InsertSetMoreStep<R> |
InsertSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
INSERT statement. |
<T> InsertSetMoreStep<R> |
InsertSetMoreStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set a value for a field in the
INSERT statement. |
<T> InsertOnDuplicateSetMoreStep<R> |
InsertOnDuplicateSetStep.set(Field<T> field,
Select<? extends Record1<T>> value)
Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause. |
<T1> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row1<T1> row,
Select<? extends Record1<T1>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
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> |
UpdateSetFirstStep.set(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row,
Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row2<T1,T2> row,
Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
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> |
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> |
UpdateSetFirstStep.set(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row,
Select<? extends Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3> UpdateFromStep<R> |
UpdateSetFirstStep.set(Row3<T1,T2,T3> row,
Select<? extends Record3<T1,T2,T3>> select)
Specify a multi-column set clause for the
UPDATE statement. |
<T1,T2,T3,T4> |
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> |
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> |
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> |
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> |
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> |
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. |
UpdateFromStep<R> |
UpdateSetFirstStep.set(RowN row,
Select<?> select)
Specify a multi-column set clause for the
UPDATE statement. |
void |
InsertQuery.setSelect(Field<?>[] fields,
Select<?> select)
Use a
SELECT statement as the source of values for the
INSERT statement. |
SelectOrderByStep<R> |
SelectUnionStep.union(Select<? extends R> select)
Apply the
UNION set operation. |
Select<R> |
Select.union(Select<? extends R> select)
Apply the
UNION set operation. |
SelectOrderByStep<R> |
SelectUnionStep.unionAll(Select<? extends R> select)
Apply the
UNION ALL set operation. |
Select<R> |
Select.unionAll(Select<? extends R> select)
Apply the
UNION ALL set operation. |
CaseConditionStep<T> |
CaseConditionStep.when(Condition condition,
Select<? extends Record1<T>> result)
Compare a condition to the already constructed case statement, return
result if the condition holds true
|
<T> CaseConditionStep<T> |
Case.when(Condition condition,
Select<? extends Record1<T>> result)
This construct can be used to create expressions of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
<T> CaseWhenStep<V,T> |
CaseValueStep.when(Field<V> compareValue,
Select<? extends Record1<T>> result)
Compare a value to the already constructed case statement, return result
if values are equal.
|
<T> CaseWhenStep<V,T> |
CaseValueStep.when(V compareValue,
Select<? extends Record1<T>> result)
Compare a value to the already constructed case statement, return result
if values are equal.
|
UpdateConditionStep<R> |
UpdateWhereStep.whereExists(Select<?> select)
Add an EXISTS clause to the query
|
SelectConditionStep<R> |
SelectWhereStep.whereExists(Select<?> select)
Add a
WHERE EXISTS clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.whereExists(Select<?> select)
Add an EXISTS clause to the query.
|
UpdateConditionStep<R> |
UpdateWhereStep.whereNotExists(Select<?> select)
Add a NOT EXISTS clause to the query
|
SelectConditionStep<R> |
SelectWhereStep.whereNotExists(Select<?> select)
Add a
WHERE NOT EXISTS clause to the query. |
DeleteConditionStep<R> |
DeleteWhereStep.whereNotExists(Select<?> select)
Add a NOT EXISTS clause to the query.
|
Modifier and Type | Method and Description |
---|---|
static <R extends Record> |
DSL.all(Select<R> select)
Create an
ALL quantified select to be used in quantified
comparison predicate expressions. |
static <R extends Record> |
DSL.any(Select<R> select)
Create an
ANY quantified select to be used in quantified
comparison predicate expressions. |
static Condition |
DSL.exists(Select<?> query)
Create an exists condition.
|
int |
DefaultDSLContext.fetchCount(Select<?> query) |
boolean |
DefaultDSLContext.fetchExists(Select<?> query) |
static <T> Field<T> |
DSL.field(Select<? extends Record1<T>> select)
Transform a subquery into a correlated subquery.
|
static Condition |
DSL.notExists(Select<?> query)
Create a not exists condition.
|
static <R extends Record> |
DSL.table(Select<R> select)
A synonym for
TableLike.asTable() , which might look a bit more fluent
like this, to some users. |
static <T> CaseConditionStep<T> |
DSL.when(Condition condition,
Select<? extends Record1<T>> result)
Initialise a
Case statement. |
Modifier and Type | Method and Description |
---|---|
static <T> Field<T[]> |
PostgresDSL.array(Select<? extends Record1<T>> select)
The PostgreSQL
array(select) function. |
Copyright © 2015. All Rights Reserved.