Module org.jooq

Package org.jooq

Interface WithStep

All Superinterfaces:

QueryPart, Serializable

public interface WithStep
extends QueryPart

This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

Example:

 DSL.with("table", "col1", "col2")
    .as(
        select(one(), two())
    )
    .select()
    .from("table")
 

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
<R extends Record> @NotNull DeleteUsingStep<R>	delete(Table<R> table)	Create a new DSL delete statement.
<R extends Record> @NotNull InsertSetStep<R>	insertInto(Table<R> into)	Create a new DSL insert statement.
<R extends Record> @NotNull InsertValuesStepN<R>	insertInto(Table<R> into, Collection<? extends Field<?>> fields)	Create a new DSL insert statement.
<R extends Record> @NotNull InsertValuesStepN<R>	insertInto(Table<R> into, Field<?>... fields)	Create a new DSL insert statement.
<R extends Record, T1> @NotNull InsertValuesStep1<R,T1>	insertInto(Table<R> into, Field<T1> field1)	Create a new DSL insert statement.
<R extends Record, T1, T2> @NotNull InsertValuesStep2<R,T1,T2>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3> @NotNull InsertValuesStep3<R,T1,T2,T3>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4> @NotNull InsertValuesStep4<R,T1,T2,T3,T4>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)	Create a new DSL insert statement.
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)	Create a new DSL insert statement.
<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> @NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)	Create a new DSL insert statement.
<R extends Record> @NotNull MergeUsingStep<R>	mergeInto(Table<R> table)	Create a new DSL SQL standard MERGE statement.
<R extends Record> @NotNull MergeKeyStepN<R>	mergeInto(Table<R> table, Collection<? extends Field<?>> fields)	Create a new DSL merge statement (H2-specific syntax).
<R extends Record> @NotNull MergeKeyStepN<R>	mergeInto(Table<R> table, Field<?>... fields)	Create a new DSL merge statement (H2-specific syntax).
<R extends Record, T1> @NotNull MergeKeyStep1<R,T1>	mergeInto(Table<R> table, Field<T1> field1)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2> @NotNull MergeKeyStep2<R,T1,T2>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3> @NotNull MergeKeyStep3<R,T1,T2,T3>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<R extends Record, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
<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> @NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
@NotNull SelectSelectStep<Record>	select(Collection<? extends SelectFieldOrAsterisk> fields)	Create a new DSL select statement.
<T1> @NotNull SelectSelectStep<Record1<T1>>	select(SelectField<T1> field1)	Create a new DSL select statement.
<T1, T2> @NotNull SelectSelectStep<Record2<T1,T2>>	select(SelectField<T1> field1, SelectField<T2> field2)	Create a new DSL select statement.
<T1, T2, T3> @NotNull SelectSelectStep<Record3<T1,T2,T3>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)	Create a new DSL select statement.
<T1, T2, T3, T4> @NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)	Create a new DSL select statement.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6> @NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7> @NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8> @NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>	select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record>	select(SelectFieldOrAsterisk... fields)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record1<Integer>>	selectCount()	Create a new DSL select statement for COUNT(*).
@NotNull SelectSelectStep<Record>	selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)	Create a new DSL select statement.
<T1> @NotNull SelectSelectStep<Record1<T1>>	selectDistinct(SelectField<T1> field1)	Create a new DSL select statement.
<T1, T2> @NotNull SelectSelectStep<Record2<T1,T2>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2)	Create a new DSL select statement.
<T1, T2, T3> @NotNull SelectSelectStep<Record3<T1,T2,T3>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)	Create a new DSL select statement.
<T1, T2, T3, T4> @NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)	Create a new DSL select statement.
<T1, T2, T3, T4, T5> @NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6> @NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7> @NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8> @NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)	Create a new DSL select statement.
<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>	selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)	Create a new DSL select statement.
@NotNull SelectSelectStep<Record>	selectDistinct(SelectFieldOrAsterisk... fields)	Create a new DSL select statement.
@NotNull SelectWhereStep<Record>	selectFrom(String sql)	Create a new DSL select statement, projecting *.
@NotNull SelectWhereStep<Record>	selectFrom(String sql, Object... bindings)	Create a new DSL select statement, projecting *.
@NotNull SelectWhereStep<Record>	selectFrom(String sql, QueryPart... parts)	Create a new DSL select statement, projecting *.
@NotNull SelectWhereStep<Record>	selectFrom(Name table)	Create a new DSL select statement, projecting *.
@NotNull SelectWhereStep<Record>	selectFrom(SQL sql)	Create a new DSL select statement, projecting *.
<R extends Record> @NotNull SelectWhereStep<R>	selectFrom(TableLike<R> table)	Create a new DSL select statement, projecting the known columns from a table.
@NotNull SelectSelectStep<Record1<Integer>>	selectOne()	Create a new DSL select statement for a constant 1 literal.
@NotNull SelectSelectStep<Record1<Integer>>	selectZero()	Create a new DSL select statement for a constant 0 literal.
<R extends Record> @NotNull UpdateSetFirstStep<R>	update(Table<R> table)	Create a new DSL update statement.
@NotNull WithAsStep	with(String alias)	Add another common table expression to the WITH clause.
@NotNull WithAsStep1	with(String alias, String fieldAlias1)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(String alias, String... fieldAliases)	Add another common table expression to the WITH clause.
@NotNull WithAsStep2	with(String alias, String fieldAlias1, String fieldAlias2)	Add another common table expression to the WITH clause.
@NotNull WithAsStep3	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)	Add another common table expression to the WITH clause.
@NotNull WithAsStep4	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4)	Add another common table expression to the WITH clause.
@NotNull WithAsStep5	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5)	Add another common table expression to the WITH clause.
@NotNull WithAsStep6	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6)	Add another common table expression to the WITH clause.
@NotNull WithAsStep7	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7)	Add another common table expression to the WITH clause.
@NotNull WithAsStep8	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8)	Add another common table expression to the WITH clause.
@NotNull WithAsStep9	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9)	Add another common table expression to the WITH clause.
@NotNull WithAsStep10	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10)	Add another common table expression to the WITH clause.
@NotNull WithAsStep11	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11)	Add another common table expression to the WITH clause.
@NotNull WithAsStep12	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12)	Add another common table expression to the WITH clause.
@NotNull WithAsStep13	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13)	Add another common table expression to the WITH clause.
@NotNull WithAsStep14	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14)	Add another common table expression to the WITH clause.
@NotNull WithAsStep15	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15)	Add another common table expression to the WITH clause.
@NotNull WithAsStep16	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16)	Add another common table expression to the WITH clause.
@NotNull WithAsStep17	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17)	Add another common table expression to the WITH clause.
@NotNull WithAsStep18	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18)	Add another common table expression to the WITH clause.
@NotNull WithAsStep19	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19)	Add another common table expression to the WITH clause.
@NotNull WithAsStep20	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20)	Add another common table expression to the WITH clause.
@NotNull WithAsStep21	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21)	Add another common table expression to the WITH clause.
@NotNull WithAsStep22	with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9, String fieldAlias10, String fieldAlias11, String fieldAlias12, String fieldAlias13, String fieldAlias14, String fieldAlias15, String fieldAlias16, String fieldAlias17, String fieldAlias18, String fieldAlias19, String fieldAlias20, String fieldAlias21, String fieldAlias22)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(String alias, Collection<String> fieldAliases)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull WithAsStep	with(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
@NotNull WithStep	with(Collection<? extends CommonTableExpression<?>> tables)	Add another common table expression to the WITH clause.
@NotNull WithStep	with(CommonTableExpression<?>... tables)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(Name alias)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(Name alias, Collection<? extends Name> fieldAliases)	Add another common table expression to the WITH clause.
@NotNull WithAsStep1	with(Name alias, Name fieldAlias1)	Add another common table expression to the WITH clause.
@NotNull WithAsStep	with(Name alias, Name... fieldAliases)	Add another common table expression to the WITH clause.
@NotNull WithAsStep2	with(Name alias, Name fieldAlias1, Name fieldAlias2)	Add another common table expression to the WITH clause.
@NotNull WithAsStep3	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)	Add another common table expression to the WITH clause.
@NotNull WithAsStep4	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4)	Add another common table expression to the WITH clause.
@NotNull WithAsStep5	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5)	Add another common table expression to the WITH clause.
@NotNull WithAsStep6	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6)	Add another common table expression to the WITH clause.
@NotNull WithAsStep7	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7)	Add another common table expression to the WITH clause.
@NotNull WithAsStep8	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8)	Add another common table expression to the WITH clause.
@NotNull WithAsStep9	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9)	Add another common table expression to the WITH clause.
@NotNull WithAsStep10	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10)	Add another common table expression to the WITH clause.
@NotNull WithAsStep11	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11)	Add another common table expression to the WITH clause.
@NotNull WithAsStep12	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12)	Add another common table expression to the WITH clause.
@NotNull WithAsStep13	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13)	Add another common table expression to the WITH clause.
@NotNull WithAsStep14	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14)	Add another common table expression to the WITH clause.
@NotNull WithAsStep15	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15)	Add another common table expression to the WITH clause.
@NotNull WithAsStep16	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16)	Add another common table expression to the WITH clause.
@NotNull WithAsStep17	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17)	Add another common table expression to the WITH clause.
@NotNull WithAsStep18	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18)	Add another common table expression to the WITH clause.
@NotNull WithAsStep19	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19)	Add another common table expression to the WITH clause.
@NotNull WithAsStep20	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20)	Add another common table expression to the WITH clause.
@NotNull WithAsStep21	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21)	Add another common table expression to the WITH clause.
@NotNull WithAsStep22	with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22)	Add another common table expression to the WITH clause.

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Method Details

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(String alias)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(String alias,
 String... fieldAliases)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(String alias,
 Collection<String> fieldAliases)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(Name alias)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(Name alias,
 Name... fieldAliases)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(Name alias,
 Collection<? extends Name> fieldAliases)

Add another common table expression to the WITH clause.

with

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(String alias,
 Function<? super Field<?>,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.

Add another common table expression to the WITH clause.

This works in a similar way as with(String, String...), except that all column names are produced by a function that receives the CTE's Select columns as input.

with

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep with(String alias,
 BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.

Add another common table expression to the WITH clause.

This works in a similar way as with(String, String...), except that all column names are produced by a function that receives the CTE's Select columns and their column indexes as input.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep1 with(String alias,
 String fieldAlias1)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep2 with(String alias,
 String fieldAlias1,
 String fieldAlias2)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep3 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep4 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep5 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep6 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep7 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep8 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep9 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep10 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep11 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep12 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep13 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep14 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep15 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep16 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep17 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep18 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17,
 String fieldAlias18)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep19 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17,
 String fieldAlias18,
 String fieldAlias19)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep20 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17,
 String fieldAlias18,
 String fieldAlias19,
 String fieldAlias20)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep21 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17,
 String fieldAlias18,
 String fieldAlias19,
 String fieldAlias20,
 String fieldAlias21)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep22 with(String alias,
 String fieldAlias1,
 String fieldAlias2,
 String fieldAlias3,
 String fieldAlias4,
 String fieldAlias5,
 String fieldAlias6,
 String fieldAlias7,
 String fieldAlias8,
 String fieldAlias9,
 String fieldAlias10,
 String fieldAlias11,
 String fieldAlias12,
 String fieldAlias13,
 String fieldAlias14,
 String fieldAlias15,
 String fieldAlias16,
 String fieldAlias17,
 String fieldAlias18,
 String fieldAlias19,
 String fieldAlias20,
 String fieldAlias21,
 String fieldAlias22)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep1 with(Name alias,
 Name fieldAlias1)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep2 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep3 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep4 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep5 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep6 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep7 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep8 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep9 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep10 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep11 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep12 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep13 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep14 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep15 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep16 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep17 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep18 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17,
 Name fieldAlias18)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep19 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17,
 Name fieldAlias18,
 Name fieldAlias19)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep20 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17,
 Name fieldAlias18,
 Name fieldAlias19,
 Name fieldAlias20)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep21 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17,
 Name fieldAlias18,
 Name fieldAlias19,
 Name fieldAlias20,
 Name fieldAlias21)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithAsStep22 with(Name alias,
 Name fieldAlias1,
 Name fieldAlias2,
 Name fieldAlias3,
 Name fieldAlias4,
 Name fieldAlias5,
 Name fieldAlias6,
 Name fieldAlias7,
 Name fieldAlias8,
 Name fieldAlias9,
 Name fieldAlias10,
 Name fieldAlias11,
 Name fieldAlias12,
 Name fieldAlias13,
 Name fieldAlias14,
 Name fieldAlias15,
 Name fieldAlias16,
 Name fieldAlias17,
 Name fieldAlias18,
 Name fieldAlias19,
 Name fieldAlias20,
 Name fieldAlias21,
 Name fieldAlias22)

Add another common table expression to the WITH clause.

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithStep with(CommonTableExpression<?>... tables)

Add another common table expression to the WITH clause.

Reusable CommonTableExpression types can be constructed through

• DSL.name(String...)
• Name.fields(String...)
• DerivedColumnList#as(Select)

with

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull WithStep with(Collection<? extends CommonTableExpression<?>> tables)

Add another common table expression to the WITH clause.

Reusable CommonTableExpression types can be constructed through

• DSL.name(String...)
• Name.fields(String...)
• DerivedColumnList#as(Select)

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<R extends Record> @NotNull SelectWhereStep<R> selectFrom(TableLike<R> table)

Create a new DSL select statement, projecting the known columns from a table.

This will project the known columns from the argument table querying Fields.fields(). If no known columns are available (e.g. because the table has been created using DSL.table(String)), then SELECT * is projected.

Example:

 SELECT table.col1, table.col2 FROM table
 

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectWhereStep<Record> selectFrom(Name table)

Create a new DSL select statement, projecting *.

Without knowing any columns from the argument table (see selectFrom(TableLike)), this will project SELECT *.

Example:

 SELECT * FROM table
 

See Also:

• DSL.table(Name)

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@PlainSQL
@NotNull SelectWhereStep<Record> selectFrom(SQL sql)

Create a new DSL select statement, projecting *.

Without knowing any columns from the argument table (see selectFrom(TableLike)), this will project SELECT *.

Example:

 SELECT * FROM table
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.table(SQL)
• SQL

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@PlainSQL
@NotNull SelectWhereStep<Record> selectFrom(String sql)

Create a new DSL select statement, projecting *.

Without knowing any columns from the argument table (see selectFrom(TableLike)), this will project SELECT *.

Example:

 SELECT * FROM table
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.table(String)
• DSL.sql(String)
• SQL

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@PlainSQL
@NotNull SelectWhereStep<Record> selectFrom(String sql,
 Object... bindings)

Create a new DSL select statement, projecting *.

Without knowing any columns from the argument table (see selectFrom(TableLike)), this will project SELECT *.

Example:

 SELECT * FROM table
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.table(String, Object...)
• DSL.sql(String, Object...)
• SQL

selectFrom

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@PlainSQL
@NotNull SelectWhereStep<Record> selectFrom(String sql,
 QueryPart... parts)

Create a new DSL select statement, projecting *.

Without knowing any columns from the argument table (see selectFrom(TableLike)), this will project SELECT *.

Example:

 SELECT * FROM table
 

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.table(String, QueryPart...)
• DSL.sql(String, QueryPart...)
• SQL

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record> select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(Collection) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.select(fields)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.select(Collection)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record> select(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectFieldOrAsterisk...) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.select(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2)
       .execute();
 

See Also:

• DSL.select(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1> @NotNull SelectSelectStep<Record1<T1>> select(SelectField<T1> field1)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Field.in(Select), Field.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1).as(subselect))
       .select(field1)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2> @NotNull SelectSelectStep<Record2<T1,T2>> select(SelectField<T1> field1,
 SelectField<T2> field2)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row2.in(Select), Row2.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2).as(subselect))
       .select(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3>
@NotNull SelectSelectStep<Record3<T1,T2,T3>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row3.in(Select), Row3.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3).as(subselect))
       .select(field1, field2, field3)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row4.in(Select), Row4.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4).as(subselect))
       .select(field1, field2, field3, field4)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5>
@NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row5.in(Select), Row5.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4, field5).as(subselect))
       .select(field1, field2, field3, field4, field5)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row6.in(Select), Row6.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f5, f6).as(subselect))
       .select(field1, field2, field3, .., field5, field6)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7>
@NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row7.in(Select), Row7.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f6, f7).as(subselect))
       .select(field1, field2, field3, .., field6, field7)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
@NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row8.in(Select), Row8.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f7, f8).as(subselect))
       .select(field1, field2, field3, .., field7, field8)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
@NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row9.in(Select), Row9.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f8, f9).as(subselect))
       .select(field1, field2, field3, .., field8, field9)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10>
@NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row10.in(Select), Row10.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f9, f10).as(subselect))
       .select(field1, field2, field3, .., field9, field10)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11>
@NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row11.in(Select), Row11.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f10, f11).as(subselect))
       .select(field1, field2, field3, .., field10, field11)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12>
@NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row12.in(Select), Row12.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f11, f12).as(subselect))
       .select(field1, field2, field3, .., field11, field12)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13>
@NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row13.in(Select), Row13.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f12, f13).as(subselect))
       .select(field1, field2, field3, .., field12, field13)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14>
@NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row14.in(Select), Row14.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f13, f14).as(subselect))
       .select(field1, field2, field3, .., field13, field14)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15>
@NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row15.in(Select), Row15.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f14, f15).as(subselect))
       .select(field1, field2, field3, .., field14, field15)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16>
@NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row16.in(Select), Row16.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f15, f16).as(subselect))
       .select(field1, field2, field3, .., field15, field16)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17>
@NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row17.in(Select), Row17.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f16, f17).as(subselect))
       .select(field1, field2, field3, .., field16, field17)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18>
@NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row18.in(Select), Row18.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f17, f18).as(subselect))
       .select(field1, field2, field3, .., field17, field18)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19>
@NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row19.in(Select), Row19.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f18, f19).as(subselect))
       .select(field1, field2, field3, .., field18, field19)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20>
@NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row20.in(Select), Row20.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f19, f20).as(subselect))
       .select(field1, field2, field3, .., field19, field20)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21>
@NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20,
 SelectField<T21> field21)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row21.in(Select), Row21.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f20, f21).as(subselect))
       .select(field1, field2, field3, .., field20, field21)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

select

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21,
T22>
@NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> select(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20,
 SelectField<T21> field21,
 SelectField<T22> field22)

Create a new DSL select statement.

This is the same as select(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row22.in(Select), Row22.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.select(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f21, f22).as(subselect))
       .select(field1, field2, field3, .., field21, field22)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record> selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(Collection) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectDistinct(fields)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(Collection)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record> selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectFieldOrAsterisk...) instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectDistinct(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1> @NotNull SelectSelectStep<Record1<T1>> selectDistinct(SelectField<T1> field1)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Field.in(Select), Field.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1).as(subselect))
       .selectDistinct(field1)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2> @NotNull SelectSelectStep<Record2<T1,T2>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row2.in(Select), Row2.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2).as(subselect))
       .selectDistinct(field1, field2)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3>
@NotNull SelectSelectStep<Record3<T1,T2,T3>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row3.in(Select), Row3.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3).as(subselect))
       .selectDistinct(field1, field2, field3)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row4.in(Select), Row4.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4).as(subselect))
       .selectDistinct(field1, field2, field3, field4)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5>
@NotNull SelectSelectStep<Record5<T1,T2,T3,T4,T5>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row5.in(Select), Row5.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4, field5).as(subselect))
       .selectDistinct(field1, field2, field3, field4, field5)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row6.in(Select), Row6.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f5, f6).as(subselect))
       .selectDistinct(field1, field2, field3, .., field5, field6)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7>
@NotNull SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row7.in(Select), Row7.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f6, f7).as(subselect))
       .selectDistinct(field1, field2, field3, .., field6, field7)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
@NotNull SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row8.in(Select), Row8.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f7, f8).as(subselect))
       .selectDistinct(field1, field2, field3, .., field7, field8)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
@NotNull SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row9.in(Select), Row9.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f8, f9).as(subselect))
       .selectDistinct(field1, field2, field3, .., field8, field9)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10>
@NotNull SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row10.in(Select), Row10.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f9, f10).as(subselect))
       .selectDistinct(field1, field2, field3, .., field9, field10)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11>
@NotNull SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row11.in(Select), Row11.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f10, f11).as(subselect))
       .selectDistinct(field1, field2, field3, .., field10, field11)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12>
@NotNull SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row12.in(Select), Row12.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f11, f12).as(subselect))
       .selectDistinct(field1, field2, field3, .., field11, field12)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13>
@NotNull SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row13.in(Select), Row13.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f12, f13).as(subselect))
       .selectDistinct(field1, field2, field3, .., field12, field13)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14>
@NotNull SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row14.in(Select), Row14.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f13, f14).as(subselect))
       .selectDistinct(field1, field2, field3, .., field13, field14)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15>
@NotNull SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row15.in(Select), Row15.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f14, f15).as(subselect))
       .selectDistinct(field1, field2, field3, .., field14, field15)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16>
@NotNull SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row16.in(Select), Row16.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f15, f16).as(subselect))
       .selectDistinct(field1, field2, field3, .., field15, field16)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17>
@NotNull SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row17.in(Select), Row17.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f16, f17).as(subselect))
       .selectDistinct(field1, field2, field3, .., field16, field17)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18>
@NotNull SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row18.in(Select), Row18.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f17, f18).as(subselect))
       .selectDistinct(field1, field2, field3, .., field17, field18)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19>
@NotNull SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row19.in(Select), Row19.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f18, f19).as(subselect))
       .selectDistinct(field1, field2, field3, .., field18, field19)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20>
@NotNull SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row20.in(Select), Row20.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f19, f20).as(subselect))
       .selectDistinct(field1, field2, field3, .., field19, field20)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21>
@NotNull SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20,
 SelectField<T21> field21)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row21.in(Select), Row21.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f20, f21).as(subselect))
       .selectDistinct(field1, field2, field3, .., field20, field21)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectDistinct

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
<T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21,
T22>
@NotNull SelectSelectStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> selectDistinct(SelectField<T1> field1,
 SelectField<T2> field2,
 SelectField<T3> field3,
 SelectField<T4> field4,
 SelectField<T5> field5,
 SelectField<T6> field6,
 SelectField<T7> field7,
 SelectField<T8> field8,
 SelectField<T9> field9,
 SelectField<T10> field10,
 SelectField<T11> field11,
 SelectField<T12> field12,
 SelectField<T13> field13,
 SelectField<T14> field14,
 SelectField<T15> field15,
 SelectField<T16> field16,
 SelectField<T17> field17,
 SelectField<T18> field18,
 SelectField<T19> field19,
 SelectField<T20> field20,
 SelectField<T21> field21,
 SelectField<T22> field22)

Create a new DSL select statement.

This is the same as selectDistinct(SelectFieldOrAsterisk...), except that it declares additional record-level typesafety, which is needed by Row22.in(Select), Row22.equal(Select) and other predicate building methods taking subselect arguments.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectDistinct(SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField, SelectField) instead.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f21, f22).as(subselect))
       .selectDistinct(field1, field2, field3, .., field21, field22)
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectDistinct(SelectFieldOrAsterisk...)
• selectDistinct(SelectFieldOrAsterisk...)

selectZero

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record1<Integer>> selectZero()

Create a new DSL select statement for a constant 0 literal.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectZero() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectZero()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.zero()
• DSL.selectZero()

selectOne

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record1<Integer>> selectOne()

Create a new DSL select statement for a constant 1 literal.

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectOne() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectOne()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.one()
• DSL.selectOne()

selectCount

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull SelectSelectStep<Record1<Integer>> selectCount()

Create a new DSL select statement for COUNT(*).

This creates an attached, renderable and executable SELECT statement from this DSLContext. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static DSL.selectCount() instead.

Example:

 DSLContext create = DSL.using(configuration);

 create.selectCount()
       .from(table1)
       .join(table2).on(field1.equal(field2))
       .where(field1.greaterThan(100))
       .orderBy(field2);
 

See Also:

• DSL.selectCount()

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record> @NotNull InsertSetStep<R> insertInto(Table<R> into)

Create a new DSL insert statement.

This type of insert may feel more convenient to some users, as it uses the UPDATE statement's SET a = b syntax.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table)
       .set(field1, value1)
       .set(field2, value2)
       .newRecord()
       .set(field1, value3)
       .set(field2, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1>
@NotNull InsertValuesStep1<R,T1> insertInto(Table<R> into,
 Field<T1> field1)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(field1).as(subselect))
       .insertInto(table, field1)
       .values(field1)
       .values(field1)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2>
@NotNull InsertValuesStep2<R,T1,T2> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2).as(subselect))
       .insertInto(table, field1, field2)
       .values(field1, field2)
       .values(field1, field2)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3>
@NotNull InsertValuesStep3<R,T1,T2,T3> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3).as(subselect))
       .insertInto(table, field1, field2, field3)
       .values(field1, field2, field3)
       .values(field1, field2, field3)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4>
@NotNull InsertValuesStep4<R,T1,T2,T3,T4> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4).as(subselect))
       .insertInto(table, field1, field2, field3, field4)
       .values(field1, field2, field3, field4)
       .values(field1, field2, field3, field4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5>
@NotNull InsertValuesStep5<R,T1,T2,T3,T4,T5> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(field1, field2, field3, field4, field5).as(subselect))
       .insertInto(table, field1, field2, field3, field4, field5)
       .values(field1, field2, field3, field4, field5)
       .values(field1, field2, field3, field4, field5)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6>
@NotNull InsertValuesStep6<R,T1,T2,T3,T4,T5,T6> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f5, f6).as(subselect))
       .insertInto(table, field1, field2, field3, .., field5, field6)
       .values(valueA1, valueA2, valueA3, .., valueA5, valueA6)
       .values(valueB1, valueB2, valueB3, .., valueB5, valueB6)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7>
@NotNull InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f6, f7).as(subselect))
       .insertInto(table, field1, field2, field3, .., field6, field7)
       .values(valueA1, valueA2, valueA3, .., valueA6, valueA7)
       .values(valueB1, valueB2, valueB3, .., valueB6, valueB7)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
@NotNull InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f7, f8).as(subselect))
       .insertInto(table, field1, field2, field3, .., field7, field8)
       .values(valueA1, valueA2, valueA3, .., valueA7, valueA8)
       .values(valueB1, valueB2, valueB3, .., valueB7, valueB8)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
@NotNull InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f8, f9).as(subselect))
       .insertInto(table, field1, field2, field3, .., field8, field9)
       .values(valueA1, valueA2, valueA3, .., valueA8, valueA9)
       .values(valueB1, valueB2, valueB3, .., valueB8, valueB9)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10>
@NotNull InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f9, f10).as(subselect))
       .insertInto(table, field1, field2, field3, .., field9, field10)
       .values(valueA1, valueA2, valueA3, .., valueA9, valueA10)
       .values(valueB1, valueB2, valueB3, .., valueB9, valueB10)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11>
@NotNull InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f10, f11).as(subselect))
       .insertInto(table, field1, field2, field3, .., field10, field11)
       .values(valueA1, valueA2, valueA3, .., valueA10, valueA11)
       .values(valueB1, valueB2, valueB3, .., valueB10, valueB11)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12>
@NotNull InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f11, f12).as(subselect))
       .insertInto(table, field1, field2, field3, .., field11, field12)
       .values(valueA1, valueA2, valueA3, .., valueA11, valueA12)
       .values(valueB1, valueB2, valueB3, .., valueB11, valueB12)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13>
@NotNull InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f12, f13).as(subselect))
       .insertInto(table, field1, field2, field3, .., field12, field13)
       .values(valueA1, valueA2, valueA3, .., valueA12, valueA13)
       .values(valueB1, valueB2, valueB3, .., valueB12, valueB13)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14>
@NotNull InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f13, f14).as(subselect))
       .insertInto(table, field1, field2, field3, .., field13, field14)
       .values(valueA1, valueA2, valueA3, .., valueA13, valueA14)
       .values(valueB1, valueB2, valueB3, .., valueB13, valueB14)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15>
@NotNull InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f14, f15).as(subselect))
       .insertInto(table, field1, field2, field3, .., field14, field15)
       .values(valueA1, valueA2, valueA3, .., valueA14, valueA15)
       .values(valueB1, valueB2, valueB3, .., valueB14, valueB15)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16>
@NotNull InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f15, f16).as(subselect))
       .insertInto(table, field1, field2, field3, .., field15, field16)
       .values(valueA1, valueA2, valueA3, .., valueA15, valueA16)
       .values(valueB1, valueB2, valueB3, .., valueB15, valueB16)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17>
@NotNull InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f16, f17).as(subselect))
       .insertInto(table, field1, field2, field3, .., field16, field17)
       .values(valueA1, valueA2, valueA3, .., valueA16, valueA17)
       .values(valueB1, valueB2, valueB3, .., valueB16, valueB17)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18>
@NotNull InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f17, f18).as(subselect))
       .insertInto(table, field1, field2, field3, .., field17, field18)
       .values(valueA1, valueA2, valueA3, .., valueA17, valueA18)
       .values(valueB1, valueB2, valueB3, .., valueB17, valueB18)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19>
@NotNull InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f18, f19).as(subselect))
       .insertInto(table, field1, field2, field3, .., field18, field19)
       .values(valueA1, valueA2, valueA3, .., valueA18, valueA19)
       .values(valueB1, valueB2, valueB3, .., valueB18, valueB19)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20>
@NotNull InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f19, f20).as(subselect))
       .insertInto(table, field1, field2, field3, .., field19, field20)
       .values(valueA1, valueA2, valueA3, .., valueA19, valueA20)
       .values(valueB1, valueB2, valueB3, .., valueB19, valueB20)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21>
@NotNull InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f20, f21).as(subselect))
       .insertInto(table, field1, field2, field3, .., field20, field21)
       .values(valueA1, valueA2, valueA3, .., valueA20, valueA21)
       .values(valueB1, valueB2, valueB3, .., valueB20, valueB21)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<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>
@NotNull InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> insertInto(Table<R> into,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21,
 Field<T22> field22)

Create a new DSL insert statement.

Example:

 using(configuration)
       .with(name("t").fields(f1, f2, f3, .., f21, f22).as(subselect))
       .insertInto(table, field1, field2, field3, .., field21, field22)
       .values(valueA1, valueA2, valueA3, .., valueA21, valueA22)
       .values(valueB1, valueB2, valueB3, .., valueB21, valueB22)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record> @NotNull InsertValuesStepN<R> insertInto(Table<R> into,
 Field<?>... fields)

Create a new DSL insert statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table, field1, field2)
       .values(value1, value2)
       .values(value3, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

insertInto

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record> @NotNull InsertValuesStepN<R> insertInto(Table<R> into,
 Collection<? extends Field<?>> fields)

Create a new DSL insert statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table, field1, field2)
       .values(value1, value2)
       .values(value3, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

update

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record> @NotNull UpdateSetFirstStep<R> update(Table<R> table)

Create a new DSL update statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.update(table)
       .set(field1, value1)
       .set(field2, value2)
       .where(field1.greaterThan(100))
       .execute();
 

Note that some databases support table expressions more complex than simple table references. In MySQL, for instance, you can write

 create.update(t1.join(t2).on(t1.id.eq(t2.id)))
       .set(t1.value, value1)
       .set(t2.value, value2)
       .where(t1.id.eq(10))
       .execute();
 

mergeInto

@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record> @NotNull MergeUsingStep<R> mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

dialect	support type	documentation
DB2	SQL:2008 standard and major enhancements	http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com. ibm.db2.udb.admin.doc/doc/r0010873.htm
HSQLDB	SQL:2008 standard	http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#N129BA
Oracle	SQL:2008 standard and minor enhancements	http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/ statements_9016.htm
SQL Server	Similar to SQL:2008 standard with some major enhancements	http://msdn.microsoft.com/de-de/library/bb510625.aspx
Sybase	Similar to SQL:2008 standard with some major enhancements	http://dcx.sybase.com/1100/en/dbreference_en11/merge-statement.html

Example:

 DSLContext create = DSL.using(configuration);

 create.mergeInto(table)
       .using(select)
       .on(condition)
       .whenMatchedThenUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .whenNotMatchedThenInsert(field1, field2)
       .values(value1, value2)
       .execute();
 

Note: Using this method, you can also create an H2-specific MERGE statement without field specification. See also mergeInto(Table, Field...)

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1> @NotNull MergeKeyStep1<R,T1> mergeInto(Table<R> table,
 Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2>
@NotNull MergeKeyStep2<R,T1,T2> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3>
@NotNull MergeKeyStep3<R,T1,T2,T3> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4>
@NotNull MergeKeyStep4<R,T1,T2,T3,T4> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5>
@NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6>
@NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7>
@NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
@NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
@NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10>
@NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11>
@NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12>
@NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13>
@NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14>
@NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15>
@NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16>
@NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17>
@NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18>
@NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19>
@NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20>
@NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record,
T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9,
T10,
T11,
T12,
T13,
T14,
T15,
T16,
T17,
T18,
T19,
T20,
T21>
@NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<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>
@NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> mergeInto(Table<R> table,
 Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21,
 Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record> @NotNull MergeKeyStepN<R> mergeInto(Table<R> table,
 Field<?>... fields)

Create a new DSL merge statement (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@NotNull
@CheckReturnValue
@Support({H2,SQLSERVER})
<R extends Record> @NotNull MergeKeyStepN<R> mergeInto(Table<R> table,
 Collection<? extends Field<?>> fields)

Create a new DSL merge statement (H2-specific syntax).

See Also:

• mergeInto(Table, Field...)

delete

@NotNull
@CheckReturnValue
@Support({AURORA_POSTGRES,COCKROACHDB,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,YUGABYTEDB})
<R extends Record> @NotNull DeleteUsingStep<R> delete(Table<R> table)

Create a new DSL delete statement.

Example:

 DSLContext create = DSL.using(configuration);

 create.delete(table)
       .where(field1.greaterThan(100))
       .execute();
 

Some but not all databases support aliased tables in delete statements.