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")
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
<R extends Record> DeleteWhereStep<R>	delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> InsertSetStep<R>	insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStepN<R>	insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record,T1> InsertValuesStep1<R,T1>	insertInto(Table<R> into, Field<T1> field1) Create a new DSL insert statement.
<R extends Record,T1,T2> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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> MergeUsingStep<R>	mergeInto(Table<R> table) Create a new DSL SQL standard MERGE statement.
<R extends Record> MergeKeyStepN<R>	mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax).
<R extends Record> MergeKeyStepN<R>	mergeInto(Table<R> table, Field<?>... fields) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1> MergeKeyStep1<R,T1>	mergeInto(Table<R> table, Field<T1> field1) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2> MergeKeyStep2<R,T1,T2>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3> MergeKeyStep3<R,T1,T2,T3>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4>	mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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) Create a new DSL merge statement (H2-specific syntax).
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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) Create a new DSL merge statement (H2-specific syntax).
<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> 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) Create a new DSL merge statement (H2-specific syntax).
SelectSelectStep<Record>	select(Collection<? extends Field<?>> fields) Create a new DSL select statement.
SelectSelectStep<Record>	select(Field<?>... fields) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	select(Field<T1> field1) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	select(Field<T1> field1, Field<T2> field2) Create a new DSL select statement.
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL select statement.
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL select statement.
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	select(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	select(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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(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 select statement.
SelectSelectStep<Record1<Integer>>	selectCount() Create a new DSL select statement for COUNT(*).
SelectSelectStep<Record>	selectDistinct(Collection<? extends Field<?>> fields) Create a new DSL select statement.
SelectSelectStep<Record>	selectDistinct(Field<?>... fields) Create a new DSL select statement.
<T1> SelectSelectStep<Record1<T1>>	selectDistinct(Field<T1> field1) Create a new DSL select statement.
<T1,T2> SelectSelectStep<Record2<T1,T2>>	selectDistinct(Field<T1> field1, Field<T2> field2) Create a new DSL select statement.
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL select statement.
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL select statement.
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>	selectDistinct(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL select statement.
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>	selectDistinct(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 select statement.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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(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 select statement.
<R extends Record> SelectWhereStep<R>	selectFrom(Table<R> table) Create a new DSL select statement.
SelectSelectStep<Record1<Integer>>	selectOne() Create a new DSL select statement for a constant 1 literal.
SelectSelectStep<Record1<Integer>>	selectZero() Create a new DSL select statement for a constant 0 literal.
<R extends Record> UpdateSetFirstStep<R>	update(Table<R> table) Create a new DSL update statement.
WithStep	with(CommonTableExpression<?>... tables) Add another common table expression to the WITH clause.
WithAsStep	with(String alias) Add another common table expression to the WITH clause.
WithAsStep	with(String alias, String... fieldAliases) Add another common table expression to the WITH clause.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

with

@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
WithAsStep with(String alias)

Add another common table expression to the WITH clause.

with

@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
WithAsStep with(String alias,
                                                                                        String... fieldAliases)

Add another common table expression to the WITH clause.

with

@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
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)

selectFrom

@Support
<R extends Record> SelectWhereStep<R> selectFrom(Table<R> table)

Create a new DSL select statement.

Example:

 SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
 

select

@Support
SelectSelectStep<Record> select(Collection<? extends Field<?>> 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

@Support
SelectSelectStep<Record> select(Field<?>... 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(Field...) 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(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1> SelectSelectStep<Record1<T1>> select(Field<T1> field1)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2> SelectSelectStep<Record2<T1,T2>> select(Field<T1> field1,
                                                                                                                           Field<T2> field2)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> select(Field<T1> field1,
                                                                                                                                 Field<T2> field2,
                                                                                                                                 Field<T3> field3)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>> select(Field<T1> field1,
                                                                                                                                       Field<T2> field2,
                                                                                                                                       Field<T3> field3,
                                                                                                                                       Field<T4> field4)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>> select(Field<T1> field1,
                                                                                                                                             Field<T2> field2,
                                                                                                                                             Field<T3> field3,
                                                                                                                                             Field<T4> field4,
                                                                                                                                             Field<T5> field5)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> select(Field<T1> field1,
                                                                                                                                                   Field<T2> field2,
                                                                                                                                                   Field<T3> field3,
                                                                                                                                                   Field<T4> field4,
                                                                                                                                                   Field<T5> field5,
                                                                                                                                                   Field<T6> field6)

Create a new DSL select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> select(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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(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 select statement.

This is the same as select(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Support
SelectSelectStep<Record> selectDistinct(Collection<? extends Field<?>> 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

@Support
SelectSelectStep<Record> selectDistinct(Field<?>... 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(Field...) 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(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1> SelectSelectStep<Record1<T1>> selectDistinct(Field<T1> field1)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2> SelectSelectStep<Record2<T1,T2>> selectDistinct(Field<T1> field1,
                                                                                                                                   Field<T2> field2)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> selectDistinct(Field<T1> field1,
                                                                                                                                         Field<T2> field2,
                                                                                                                                         Field<T3> field3)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>> selectDistinct(Field<T1> field1,
                                                                                                                                               Field<T2> field2,
                                                                                                                                               Field<T3> field3,
                                                                                                                                               Field<T4> field4)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>> selectDistinct(Field<T1> field1,
                                                                                                                                                     Field<T2> field2,
                                                                                                                                                     Field<T3> field3,
                                                                                                                                                     Field<T4> field4,
                                                                                                                                                     Field<T5> field5)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>> selectDistinct(Field<T1> field1,
                                                                                                                                                           Field<T2> field2,
                                                                                                                                                           Field<T3> field3,
                                                                                                                                                           Field<T4> field4,
                                                                                                                                                           Field<T5> field5,
                                                                                                                                                           Field<T6> field6)

Create a new DSL select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> SelectSelectStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> SelectSelectStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> SelectSelectStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> SelectSelectStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> SelectSelectStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> SelectSelectStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> SelectSelectStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> SelectSelectStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> SelectSelectStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> SelectSelectStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> SelectSelectStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> selectDistinct(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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(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 select statement.

This is the same as selectDistinct(Field...), 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(Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field) 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(Field...), selectDistinct(Field...)

selectZero

@Support
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

@Support
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

@Support
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

@Support
<R extends Record> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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

@Generated(value="This method was generated using jOOQ-tools")
 @Support
<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> 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

@Support
<R extends Record> 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

@Support
<R extends Record> 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

@Support
<R extends Record> 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 CUBRID and 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

@Support(value={CUBRID,DB2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record> 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
CUBRID	SQL:2008 standard and some enhancements	http://www.cubrid.org/manual/90/en/MERGE
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

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1> MergeKeyStep1<R,T1> mergeInto(Table<R> table,
                                                                                                                                                                                     Field<T1> field1)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2> MergeKeyStep2<R,T1,T2> mergeInto(Table<R> table,
                                                                                                                                                                                           Field<T1> field1,
                                                                                                                                                                                           Field<T2> field2)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3> MergeKeyStep3<R,T1,T2,T3> mergeInto(Table<R> table,
                                                                                                                                                                                                 Field<T1> field1,
                                                                                                                                                                                                 Field<T2> field2,
                                                                                                                                                                                                 Field<T3> field3)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4> mergeInto(Table<R> table,
                                                                                                                                                                                                       Field<T1> field1,
                                                                                                                                                                                                       Field<T2> field2,
                                                                                                                                                                                                       Field<T3> field3,
                                                                                                                                                                                                       Field<T4> field4)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<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> 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)

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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record> 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	www.h2database.com/html/grammar.html#merge
DB2, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can simulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See mergeInto(Table) for the standard MERGE statement

mergeInto

@Support(value={CUBRID,DB2,H2,HSQLDB,ORACLE,SQLSERVER,SYBASE})
<R extends Record> 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

@Support
<R extends Record> DeleteWhereStep<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.