Top Description Methods
org.jooq

public Interface WithStep

extends QueryPart
Known Direct Implementers
org.jooq.impl.WithImpl
Static Imports
org.jooq.SQLDialect.*
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:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public <R extends Record> @NotNull DeleteUsingStep<R>
delete(Table<R> table)

Deprecated as a consequence of DeleteUsingStep being deprecated.
Create a new DSL delete statement.
public <R extends Record> @NotNull InsertSetStep<R>
insertInto(Table<R> into)

Create a new DSL insert statement.

public <R extends Record, T1> @NotNull InsertValuesStep1<R, T1>
insertInto(Table<R> into, Field<T1> field1)

Deprecated as a consequence of Field and InsertValuesStep1 being deprecated.
Create a new DSL insert statement.
public <R extends Record, T1, T2> @NotNull InsertValuesStep2<R, T1, T2>
insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field and InsertValuesStep2 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep3 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep4 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep5 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep6 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep7 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep8 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep9 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep10 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep11 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep12 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep13 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep14 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep15 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep16 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep17 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep18 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep19 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep20 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep21 being deprecated.
Create a new DSL insert statement.
public <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)

Deprecated as a consequence of Field and InsertValuesStep22 being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull InsertValuesStepN<R>
insertInto(Table<R> into, Field<?>... fields)

Deprecated as a consequence of Field and InsertValuesStepN being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull InsertValuesStepN<R>
insertInto(Table<R> into, Collection<? extends Field<?>> fields)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Create a new DSL insert statement.
public <R extends Record> @NotNull MergeUsingStep<R>
mergeInto(Table<R> table)

Create a new DSL SQL standard MERGE statement.

public <R extends Record, T1> @NotNull MergeKeyStep1<R, T1>
mergeInto(Table<R> table, Field<T1> field1)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <R extends Record, T1, T2> @NotNull MergeKeyStep2<R, T1, T2>
mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)

Deprecated for removal since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <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 since 3.14. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via mergeInto(Table)
Create a new DSL merge statement (H2-specific syntax).
public <R extends Record> @NotNull MergeKeyStepN<R>
mergeInto(Table<R> table, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Create a new DSL merge statement (H2-specific syntax).
public <R extends Record> @NotNull MergeKeyStepN<R>
mergeInto(Table<R> table, Collection<? extends Field<?>> fields)

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

public @NotNull SelectSelectStep<Record>
select(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

public @NotNull SelectSelectStep<Record>
select(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

public <T1> @NotNull SelectSelectStep<Record1<T1>>
select(SelectField<T1> field1)

Create a new DSL select statement.

public <T1, T2> @NotNull SelectSelectStep<Record2<T1, T2>>
select(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public @NotNull SelectSelectStep<Record1<Integer>>
selectCount()

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

public @NotNull SelectSelectStep<Record>
selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)

Create a new DSL select statement.

public @NotNull SelectSelectStep<Record>
selectDistinct(SelectFieldOrAsterisk... fields)

Create a new DSL select statement.

public <T1> @NotNull SelectSelectStep<Record1<T1>>
selectDistinct(SelectField<T1> field1)

Create a new DSL select statement.

public <T1, T2> @NotNull SelectSelectStep<Record2<T1, T2>>
selectDistinct(SelectField<T1> field1, SelectField<T2> field2)

Create a new DSL select statement.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <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.

public <R extends Record> @NotNull SelectWhereStep<R>
selectFrom(TableLike<R> table)

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

public @NotNull SelectWhereStep<Record>
selectFrom(Name table)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(SQL sql)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql, Object... bindings)

Create a new DSL select statement, projecting *.

public @NotNull SelectWhereStep<Record>
selectFrom(String sql, QueryPart... parts)

Create a new DSL select statement, projecting *.

public @NotNull SelectSelectStep<Record1<Integer>>
selectOne()

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

public @NotNull SelectSelectStep<Record1<Integer>>
selectZero()

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

public <R extends Record> @NotNull UpdateSetFirstStep<R>
update(Table<R> table)

Create a new DSL update statement.

public @NotNull WithAsStep
with(String alias)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(String alias, String... fieldAliases)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(String alias, Collection<String> fieldAliases)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(Name alias)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(Name alias, Name... fieldAliases)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(Name alias, Collection<? extends Name> fieldAliases)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep
with(String alias, Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Add another common table expression to the WITH clause.
public @NotNull WithAsStep
with(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Add another common table expression to the WITH clause.
public @NotNull WithAsStep1
with(String alias, String fieldAlias1)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep2
with(String alias, String fieldAlias1, String fieldAlias2)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep3
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep4
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep5
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5)

Add another common table expression to the WITH clause.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @NotNull WithAsStep1
with(Name alias, Name fieldAlias1)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep2
with(Name alias, Name fieldAlias1, Name fieldAlias2)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep3
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep4
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4)

Add another common table expression to the WITH clause.

public @NotNull WithAsStep5
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5)

Add another common table expression to the WITH clause.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @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.

public @NotNull WithStep
with(CommonTableExpression<?>... tables)

Add another common table expression to the WITH clause.

public @NotNull WithStep
with(Collection<? extends CommonTableExpression<?>> tables)

Add another common table expression to the WITH clause.

Inherited from org.jooq.QueryPart:
equalshashCodetoString