DSL (jOOQ 3.6.4 API)

java.lang.Object
- org.jooq.impl.DSL

Direct Known Subclasses:

AccessDSL, ASEDSL, CUBRIDDSL, DB2DSL, DerbyDSL, FirebirdDSL, H2DSL, HanaDSL, HSQLDBDSL, InformixDSL, IngresDSL, MariaDBDSL, MySQLDSL, OracleDSL, PostgresDSL, SQLiteDSL, SQLServerDSL, SybaseDSL
```
public class DSL
extends java.lang.Object
```
A DSL "entry point" providing implementations to the org.jooq interfaces.
The DSLContext and this DSL are the main entry point for client code, to access jOOQ classes and functionality. Here, you can instantiate all of those objects that cannot be accessed through other objects. For example, to create a Field representing a constant value, you can write:
```
 Field<String> field = DSL.val("Hello World")
 
```
Another example is the EXISTS clause, which you can apply to any SELECT to form a Condition:
```
 Condition condition = DSL.exists(DSL.select(...));
 
```
DSL and static imports

For increased fluency and readability of your jOOQ client code, it is recommended that you static import all methods from the DSL. For example:
```
 import static org.jooq.impl.DSL.*;

 public class Main {
   public static void main(String[] args) {
     DSL.select(val("Hello"), inline("World"));
     // DSL.val ^^^           ^^^^^^ DSL.inline
   }
 }
 
```
In order to use the "contextual DSL", call one of the various overloaded using(Configuration) methods:
```
 // Create and immediately execute a SELECT statement:
 DSL.using(connection, dialect)
    .selectOne()
    .fetch();
 
```
Author:

Lukas Eder

See Also:

DSLContext

Constructor Summary

Constructors
Modifier Constructor and Description

protected DSL()
No instances.

Constructors
Modifier	Constructor and Description
`protected`	`DSL()` No instances.

Method Summary

All Methods Static Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`static <T extends java.lang.Number> Field<T>`	`abs(Field<T> field)` Get the absolute value of a numeric field: abs(field).
`static <T extends java.lang.Number> Field<T>`	`abs(T value)` Get the absolute value of a numeric field: abs(field).
`static Field<java.math.BigDecimal>`	`acos(Field<? extends java.lang.Number> field)` Get the arc cosine(field) function.
`static Field<java.math.BigDecimal>`	`acos(java.lang.Number value)` Get the arc cosine(field) function.
`static <T> QuantifiedSelect<Record1<T>>`	`all(Field<T[]> array)` Create an `ALL` quantified select to be used in quantified comparison predicate expressions.
`static <R extends Record> QuantifiedSelect<R>`	`all(Select<R> select)` Create an `ALL` quantified select to be used in quantified comparison predicate expressions.
`static <T> QuantifiedSelect<Record1<T>>`	`all(T... array)` Create an `ALL` quantified select to be used in quantified comparison predicate expressions.
`static AlterSequenceRestartStep<java.math.BigInteger>`	`alterSequence(Name sequence)` Create a new DSL `ALTER SEQUENCE` statement.
`static <T extends java.lang.Number> AlterSequenceRestartStep<T>`	`alterSequence(Sequence<T> sequence)` Create a new DSL `ALTER SEQUENCE` statement.
`static AlterSequenceRestartStep<java.math.BigInteger>`	`alterSequence(java.lang.String sequence)` Create a new DSL `ALTER SEQUENCE` statement.
`static AlterTableStep`	`alterTable(Name table)` Create a new DSL `ALTER TABLE` statement.
`static AlterTableStep`	`alterTable(java.lang.String table)` Create a new DSL `ALTER TABLE` statement.
`static AlterTableStep`	`alterTable(Table<?> table)` Create a new DSL `ALTER TABLE` statement.
`static Condition`	`and(java.util.Collection<? extends Condition> conditions)` Return a `Condition` that connects all argument `conditions` with `Operator.AND`.
`static Condition`	`and(Condition... conditions)` Return a `Condition` that connects all argument `conditions` with `Operator.AND`.
`static <T> QuantifiedSelect<Record1<T>>`	`any(Field<T[]> array)` Create an `ANY` quantified select to be used in quantified comparison predicate expressions.
`static <R extends Record> QuantifiedSelect<R>`	`any(Select<R> select)` Create an `ANY` quantified select to be used in quantified comparison predicate expressions.
`static <T> QuantifiedSelect<Record1<T>>`	`any(T... array)` Create an `ANY` quantified select to be used in quantified comparison predicate expressions.
`static <T> ArrayAggOrderByStep<T[]>`	`arrayAgg(Field<T> field)` Get the `array_agg()` aggregate function.
`static Field<java.lang.Integer>`	`ascii(Field<java.lang.String> field)` Get the ascii(field) function.
`static Field<java.lang.Integer>`	`ascii(java.lang.String field)` Get the ascii(field) function.
`static Field<java.math.BigDecimal>`	`asin(Field<? extends java.lang.Number> field)` Get the arc sine(field) function.
`static Field<java.math.BigDecimal>`	`asin(java.lang.Number value)` Get the arc sine(field) function.
`static Field<java.math.BigDecimal>`	`atan(Field<? extends java.lang.Number> field)` Get the arc tangent(field) function.
`static Field<java.math.BigDecimal>`	`atan(java.lang.Number value)` Get the arc tangent(field) function.
`static Field<java.math.BigDecimal>`	`atan2(Field<? extends java.lang.Number> x, Field<? extends java.lang.Number> y)` Get the atan2(field, y) function.
`static Field<java.math.BigDecimal>`	`atan2(Field<? extends java.lang.Number> x, java.lang.Number y)` Get the atan2(field, y) function.
`static Field<java.math.BigDecimal>`	`atan2(java.lang.Number x, Field<? extends java.lang.Number> y)` Get the atan2(field, y) function.
`static Field<java.math.BigDecimal>`	`atan2(java.lang.Number x, java.lang.Number y)` Get the atan2(field, y) function.
`static AggregateFunction<java.math.BigDecimal>`	`avg(Field<? extends java.lang.Number> field)` Get the average over a numeric field: avg(field).
`static AggregateFunction<java.math.BigDecimal>`	`avgDistinct(Field<? extends java.lang.Number> field)` Get the average over a numeric field: avg(distinct field).
`static <T extends java.lang.Number> Field<T>`	`bitAnd(Field<T> field1, Field<T> field2)` The bitwise and operator.
`static <T extends java.lang.Number> Field<T>`	`bitAnd(Field<T> value1, T value2)` The bitwise and operator.
`static <T extends java.lang.Number> Field<T>`	`bitAnd(T value1, Field<T> value2)` The bitwise and operator.
`static <T extends java.lang.Number> Field<T>`	`bitAnd(T value1, T value2)` The bitwise and operator.
`static Field<java.lang.Integer>`	`bitCount(Field<? extends java.lang.Number> field)` The MySQL `BIT_COUNT(field)` function, counting the number of bits that are set in this number.
`static Field<java.lang.Integer>`	`bitCount(java.lang.Number value)` The MySQL `BIT_COUNT(field)` function, counting the number of bits that are set in this number.
`static Field<java.lang.Integer>`	`bitLength(Field<java.lang.String> field)` Get the bit_length(field) function.
`static Field<java.lang.Integer>`	`bitLength(java.lang.String value)` Get the bit_length(field) function.
`static <T extends java.lang.Number> Field<T>`	`bitNand(Field<T> field1, Field<T> field2)` The bitwise not and operator.
`static <T extends java.lang.Number> Field<T>`	`bitNand(Field<T> value1, T value2)` The bitwise not and operator.
`static <T extends java.lang.Number> Field<T>`	`bitNand(T value1, Field<T> value2)` The bitwise not and operator.
`static <T extends java.lang.Number> Field<T>`	`bitNand(T value1, T value2)` The bitwise not and operator.
`static <T extends java.lang.Number> Field<T>`	`bitNor(Field<T> field1, Field<T> field2)` The bitwise not or operator.
`static <T extends java.lang.Number> Field<T>`	`bitNor(Field<T> value1, T value2)` The bitwise not or operator.
`static <T extends java.lang.Number> Field<T>`	`bitNor(T value1, Field<T> value2)` The bitwise not or operator.
`static <T extends java.lang.Number> Field<T>`	`bitNor(T value1, T value2)` The bitwise not or operator.
`static <T extends java.lang.Number> Field<T>`	`bitNot(Field<T> field)` The bitwise not operator.
`static <T extends java.lang.Number> Field<T>`	`bitNot(T value)` The bitwise not operator.
`static <T extends java.lang.Number> Field<T>`	`bitOr(Field<T> field1, Field<T> field2)` The bitwise or operator.
`static <T extends java.lang.Number> Field<T>`	`bitOr(Field<T> value1, T value2)` The bitwise or operator.
`static <T extends java.lang.Number> Field<T>`	`bitOr(T value1, Field<T> value2)` The bitwise or operator.
`static <T extends java.lang.Number> Field<T>`	`bitOr(T value1, T value2)` The bitwise or operator.
`static <T extends java.lang.Number> Field<T>`	`bitXNor(Field<T> field1, Field<T> field2)` The bitwise not xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXNor(Field<T> value1, T value2)` The bitwise not xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXNor(T value1, Field<T> value2)` The bitwise not xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXNor(T value1, T value2)` The bitwise not xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXor(Field<T> field1, Field<T> field2)` The bitwise xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXor(Field<T> value1, T value2)` The bitwise xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXor(T value1, Field<T> value2)` The bitwise xor operator.
`static <T extends java.lang.Number> Field<T>`	`bitXor(T value1, T value2)` The bitwise xor operator.
`static <T> Field<T>`	`cast(Field<?> field, java.lang.Class<T> type)` Cast a field to another type.
`static <T> Field<T>`	`cast(Field<?> field, DataType<T> type)` Cast a field to another type.
`static <T> Field<T>`	`cast(Field<?> field, Field<T> as)` Cast a field to the type of another field.
`static <T> Field<T>`	`cast(java.lang.Object value, java.lang.Class<T> type)` Cast a value to another type.
`static <T> Field<T>`	`cast(java.lang.Object value, DataType<T> type)` Cast a value to another type.
`static <T> Field<T>`	`cast(java.lang.Object value, Field<T> as)` Cast a value to the type of another field.
`static <T> Field<T>`	`castNull(java.lang.Class<T> type)` Cast null to a type.
`static <T> Field<T>`	`castNull(DataType<T> type)` Cast null to a type.
`static <T> Field<T>`	`castNull(Field<T> as)` Cast null to the type of another field.
`static <T extends java.lang.Number> Field<T>`	`ceil(Field<T> field)` Get the smallest integer value not less than [field].
`static <T extends java.lang.Number> Field<T>`	`ceil(T value)` Get the smallest integer value not less than [this].
`static Field<java.lang.Integer>`	`charLength(Field<java.lang.String> field)` Get the char_length(field) function.
`static Field<java.lang.Integer>`	`charLength(java.lang.String value)` Get the char_length(field) function.
`static Case`	`choose()` Initialise a `Case` statement.
`static <V> CaseValueStep<V>`	`choose(Field<V> value)` Initialise a `Case` statement.
`static <V> CaseValueStep<V>`	`choose(V value)` Initialise a `Case` statement.
`static <T> Field<T>`	`coalesce(Field<T> field, Field<?>... fields)` The `COALESCE(field1, field2, ... , field n)` function.
`static <T> Field<T>`	`coalesce(Field<T> field, T value)` The `COALESCE(field, value)` function.
`static <T> Field<T>`	`coalesce(T value, T... values)` The `COALESCE(value1, value2, ... , value n)` function.
`static <T> Field<T>`	`coerce(Field<?> field, java.lang.Class<T> as)` Coerce this field to another type.
`static <T> Field<T>`	`coerce(Field<?> field, DataType<T> as)` Coerce a field to another type.
`static <T> Field<T>`	`coerce(Field<?> field, Field<T> as)` Coerce this field to the type of another field.
`static <T> Field<T>`	`coerce(java.lang.Object value, java.lang.Class<T> as)` Coerce this field to another type.
`static <T> Field<T>`	`coerce(java.lang.Object value, DataType<T> as)` Coerce a field to another type.
`static <T> Field<T>`	`coerce(java.lang.Object value, Field<T> as)` Coerce this field to the type of another field.
`static Field<java.lang.String>`	`concat(Field<?>... fields)` Get the concat(field[, field, ...]) function.
`static Field<java.lang.String>`	`concat(Field<java.lang.String> field, java.lang.String value)` Get the `concat(field, value)` function.
`static Field<java.lang.String>`	`concat(java.lang.String... values)` Get the concat(value[, value, ...]) function.
`static Field<java.lang.String>`	`concat(java.lang.String value, Field<java.lang.String> field)` Get the `concat(value, field)` function.
`static Condition`	`condition(java.lang.Boolean value)` Create a condition from a boolean field.
`static Condition`	`condition(Field<java.lang.Boolean> field)` Create a condition from a boolean field.
`static Condition`	`condition(Operator operator, java.util.Collection<? extends Condition> conditions)` Return a `Condition` that connects all argument `conditions` with `Operator`.
`static Condition`	`condition(Operator operator, Condition... conditions)` Return a `Condition` that connects all argument `conditions` with `Operator`.
`static Condition`	`condition(java.lang.String sql)` Create a new condition holding plain SQL.
`static Condition`	`condition(java.lang.String sql, java.lang.Object... bindings)` Create a new condition holding plain SQL.
`static Condition`	`condition(java.lang.String sql, QueryPart... parts)` A custom SQL clause that can render arbitrary SQL elements.
`static Field<java.lang.Boolean>`	`connectByIsCycle()` Retrieve the Oracle-specific `CONNECT_BY_ISCYCLE` pseudo-field (to be used along with `CONNECT BY` clauses).
`static Field<java.lang.Boolean>`	`connectByIsLeaf()` Retrieve the Oracle-specific `CONNECT_BY_ISLEAF` pseudo-field (to be used along with `CONNECT BY` clauses).
`static <T> Field<T>`	`connectByRoot(Field<T> field)` Retrieve the Oracle-specific `CONNECT_BY_ROOT` pseudo-column (to be used along with `CONNECT BY` clauses).
`static ConstraintTypeStep`	`constraint(java.lang.String name)`
`static Field<java.math.BigDecimal>`	`cos(Field<? extends java.lang.Number> field)` Get the cosine(field) function.
`static Field<java.math.BigDecimal>`	`cos(java.lang.Number value)` Get the cosine(field) function.
`static Field<java.math.BigDecimal>`	`cosh(Field<? extends java.lang.Number> field)` Get the hyperbolic cosine function: cosh(field).
`static Field<java.math.BigDecimal>`	`cosh(java.lang.Number value)` Get the hyperbolic cosine function: cosh(field).
`static Field<java.math.BigDecimal>`	`cot(Field<? extends java.lang.Number> field)` Get the cotangent(field) function.
`static Field<java.math.BigDecimal>`	`cot(java.lang.Number value)` Get the cotangent(field) function.
`static Field<java.math.BigDecimal>`	`coth(Field<? extends java.lang.Number> field)` Get the hyperbolic cotangent function: coth(field).
`static Field<java.math.BigDecimal>`	`coth(java.lang.Number value)` Get the hyperbolic cotangent function: coth(field).
`static AggregateFunction<java.lang.Integer>`	`count()` Get the count(*) function.
`static AggregateFunction<java.lang.Integer>`	`count(Field<?> field)` Get the count(field) function.
`static AggregateFunction<java.lang.Integer>`	`count(Table<?> table)` Get the count(table) function.
`static AggregateFunction<java.lang.Integer>`	`countDistinct(Field<?>... fields)` Get the count(distinct field1, field2) function.
`static AggregateFunction<java.lang.Integer>`	`countDistinct(Field<?> field)` Get the count(distinct field) function.
`static AggregateFunction<java.lang.Integer>`	`countDistinct(Table<?> table)` Get the count(distinct table) function.
`static CreateTableAsStep<Record>`	`createGlobalTemporaryTable(Name table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateTableAsStep<Record>`	`createGlobalTemporaryTable(java.lang.String table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateTableAsStep<Record>`	`createGlobalTemporaryTable(Table<?> table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateIndexStep`	`createIndex(Name index)` Create a new DSL `CREATE INDEX` statement.
`static CreateIndexStep`	`createIndex(java.lang.String index)` Create a new DSL `CREATE INDEX` statement.
`static CreateSequenceFinalStep`	`createSequence(Name sequence)` Create a new DSL `CREATE SEQUENCE` statement.
`static CreateSequenceFinalStep`	`createSequence(Sequence<?> sequence)` Create a new DSL `CREATE SEQUENCE` statement.
`static CreateSequenceFinalStep`	`createSequence(java.lang.String sequence)` Create a new DSL `CREATE SEQUENCE` statement.
`static CreateTableAsStep<Record>`	`createTable(Name table)` Create a new DSL `CREATE TABLE` statement.
`static CreateTableAsStep<Record>`	`createTable(java.lang.String table)` Create a new DSL `CREATE TABLE` statement.
`static CreateTableAsStep<Record>`	`createTable(Table<?> table)` Create a new DSL `CREATE TABLE` statement.
`static CreateTableAsStep<Record>`	`createTemporaryTable(Name table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateTableAsStep<Record>`	`createTemporaryTable(java.lang.String table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateTableAsStep<Record>`	`createTemporaryTable(Table<?> table)` Create a new DSL `CREATE GLOBAL TEMPORARY TABLE` statement.
`static CreateViewAsStep`	`createView(Name view, Name... fields)` Create a new DSL `CREATE VIEW` statement.
`static CreateViewAsStep`	`createView(java.lang.String view, java.lang.String... fields)` Create a new DSL `CREATE VIEW` statement.
`static CreateViewAsStep`	`createView(Table<?> view, Field<?>... fields)` Create a new DSL `CREATE VIEW` statement.
`static GroupField`	`cube(Field<?>... fields)` Create a CUBE(field1, field2, .., fieldn) grouping field.
`static WindowOverStep<java.math.BigDecimal>`	`cumeDist()` The `cume_dist() over ([analytic clause])` function.
`static OrderedAggregateFunction<java.math.BigDecimal>`	`cumeDist(Field<?>... fields)` The `cume_dist(expr) within group (order by [order clause])` ordered aggregate function.
`static Field<java.sql.Date>`	`currentDate()` Get the current_date() function.
`static Field<java.sql.Time>`	`currentTime()` Get the current_time() function.
`static Field<java.sql.Timestamp>`	`currentTimestamp()` Get the current_timestamp() function.
`static Field<java.lang.String>`	`currentUser()` Get the current_user() function.
`static Field<java.sql.Date>`	`date(java.util.Date value)` Convert a temporal value to a `DATE`.
`static Field<java.sql.Date>`	`date(Field<? extends java.util.Date> field)` Convert a temporal value to a `DATE`.
`static Field<java.sql.Date>`	`date(java.lang.String value)` Convert a string value to a `DATE`.
`static Field<java.sql.Date>`	`dateAdd(java.sql.Date date, Field<? extends java.lang.Number> interval, DatePart datePart)` Add an interval to a date, given a date part.
`static Field<java.sql.Date>`	`dateAdd(java.sql.Date date, java.lang.Number interval)` Add an interval to a date.
`static Field<java.sql.Date>`	`dateAdd(java.sql.Date date, java.lang.Number interval, DatePart datePart)` Add an interval to a date, given a date part.
`static Field<java.sql.Date>`	`dateAdd(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval)` Add an interval to a date.
`static Field<java.sql.Date>`	`dateAdd(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval, DatePart datePart)` Add an interval to a date, given a date part.
`static Field<java.sql.Date>`	`dateAdd(Field<java.sql.Date> date, java.lang.Number interval, DatePart datePart)` Add an interval to a date, given a date part.
`static Field<java.lang.Integer>`	`dateDiff(java.sql.Date date1, java.sql.Date date2)` Get the date difference in number of days.
`static Field<java.lang.Integer>`	`dateDiff(java.sql.Date date1, Field<java.sql.Date> date2)` Get the date difference in number of days.
`static Field<java.lang.Integer>`	`dateDiff(Field<java.sql.Date> date1, java.sql.Date date2)` Get the date difference in number of days.
`static Field<java.lang.Integer>`	`dateDiff(Field<java.sql.Date> date1, Field<java.sql.Date> date2)` Get the date difference in number of days.
`static Field<java.sql.Date>`	`dateSub(java.sql.Date date, Field<? extends java.lang.Number> interval, DatePart datePart)` Subtract an interval from a date, given a date part.
`static Field<java.sql.Date>`	`dateSub(java.sql.Date date, java.lang.Number interval)` Subtract an interval from a date.
`static Field<java.sql.Date>`	`dateSub(java.sql.Date date, java.lang.Number interval, DatePart datePart)` Subtract an interval from a date, given a date part.
`static Field<java.sql.Date>`	`dateSub(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval)` Subtract an interval from a date.
`static Field<java.sql.Date>`	`dateSub(Field<java.sql.Date> date, Field<? extends java.lang.Number> interval, DatePart datePart)` Subtract an interval from a date, given a date part.
`static Field<java.sql.Date>`	`dateSub(Field<java.sql.Date> date, java.lang.Number interval, DatePart datePart)` Subtract an interval from a date, given a date part.
`static Field<java.lang.Integer>`	`day(java.util.Date value)` Get the day part of a date.
`static Field<java.lang.Integer>`	`day(Field<? extends java.util.Date> field)` Get the day part of a date.
`static Case`	`decode()` Initialise a `Case` statement.
`static <Z,T> Field<Z>`	`decode(Field<T> value, Field<T> search, Field<Z> result)` Gets the Oracle-style `DECODE(expression, search, result[, search , result]... [, default])` function.
`static <Z,T> Field<Z>`	`decode(Field<T> value, Field<T> search, Field<Z> result, Field<?>... more)` Gets the Oracle-style `DECODE(expression, search, result[, search , result]... [, default])` function.
`static <Z,T> Field<Z>`	`decode(T value, T search, Z result)` Gets the Oracle-style `DECODE(expression, search, result[, search , result]... [, default])` function.
`static <Z,T> Field<Z>`	`decode(T value, T search, Z result, java.lang.Object... more)` Gets the Oracle-style `DECODE(expression, search, result[, search , result]... [, default])` function.
`static Field<java.lang.Object>`	`defaultValue()` Create a `DEFAULT` keyword for use with `INSERT`, `UPDATE`, or `MERGE` statements.
`static <T> Field<T>`	`defaultValue(java.lang.Class<T> type)` Create a `DEFAULT` keyword for use with `INSERT`, `UPDATE`, or `MERGE` statements.
`static <T> Field<T>`	`defaultValue(DataType<T> type)` Create a `DEFAULT` keyword for use with `INSERT`, `UPDATE`, or `MERGE` statements.
`static <T> Field<T>`	`defaultValue(Field<T> field)` Create a `DEFAULT` keyword for use with `INSERT`, `UPDATE`, or `MERGE` statements.
`static Field<java.math.BigDecimal>`	`deg(Field<? extends java.lang.Number> field)` Calculate degrees from radians from this field.
`static Field<java.math.BigDecimal>`	`deg(java.lang.Number value)` Calculate degrees from radians from this field.
`static <R extends Record> DeleteWhereStep<R>`	`delete(Table<R> table)` Create a new DSL delete statement.
`static <R extends Record> DeleteWhereStep<R>`	`deleteFrom(Table<R> table)` Create a new DSL delete statement.
`static WindowOverStep<java.lang.Integer>`	`denseRank()` The `dense_rank() over ([analytic clause])` function.
`static OrderedAggregateFunction<java.lang.Integer>`	`denseRank(Field<?>... fields)` The `dense_rank(expr) within group (order by [order clause])` ordered aggregate function.
`static DropIndexOnStep`	`dropIndex(Name index)` Create a new DSL `DROP INDEX` statement.
`static DropIndexOnStep`	`dropIndex(java.lang.String index)` Create a new DSL `DROP INDEX` statement.
`static DropIndexOnStep`	`dropIndexIfExists(Name index)` Create a new DSL `DROP INDEX IF EXISTS` statement.
`static DropIndexOnStep`	`dropIndexIfExists(java.lang.String index)` Create a new DSL `DROP INDEX IF EXISTS` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequence(Name sequence)` Create a new DSL `DROP SEQUENCE` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequence(Sequence<?> sequence)` Create a new DSL `DROP SEQUENCE` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequence(java.lang.String sequence)` Create a new DSL `DROP SEQUENCE` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequenceIfExists(Name sequence)` Create a new DSL `DROP SEQUENCE IF EXISTS` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequenceIfExists(Sequence<?> sequence)` Create a new DSL `DROP SEQUENCE IF EXISTS` statement.
`static <T extends java.lang.Number> DropSequenceFinalStep`	`dropSequenceIfExists(java.lang.String sequence)` Create a new DSL `DROP SEQUENCE IF EXISTS` statement.
`static DropTableStep`	`dropTable(Name table)` Create a new DSL `DROP TABLE IF EXISTS` statement.
`static DropTableStep`	`dropTable(java.lang.String table)` Create a new DSL `DROP TABLE IF EXISTS` statement.
`static DropTableStep`	`dropTable(Table<?> table)` Create a new DSL `DROP TABLE` statement.
`static DropTableStep`	`dropTableIfExists(Name table)` Create a new DSL `DROP TABLE` statement.
`static DropTableStep`	`dropTableIfExists(java.lang.String table)` Create a new DSL `DROP TABLE` statement.
`static DropTableStep`	`dropTableIfExists(Table<?> table)` Create a new DSL `DROP TABLE IF EXISTS` statement.
`static DropViewFinalStep`	`dropView(Name view)` Create a new DSL `DROP VIEW` statement.
`static DropViewFinalStep`	`dropView(java.lang.String view)` Create a new DSL `DROP VIEW` statement.
`static DropViewFinalStep`	`dropView(Table<?> view)` Create a new DSL `DROP VIEW` statement.
`static DropViewFinalStep`	`dropViewIfExists(Name view)` Create a new DSL `DROP VIEW IF EXISTS` statement.
`static DropViewFinalStep`	`dropViewIfExists(java.lang.String view)` Create a new DSL `DROP VIEW IF EXISTS` statement.
`static DropViewFinalStep`	`dropViewIfExists(Table<?> view)` Create a new DSL `DROP VIEW IF EXISTS` statement.
`static Table<Record>`	`dual()` The `DUAL` table to be used for syntactic completeness.
`static Field<java.math.BigDecimal>`	`e()` The `E` literal (Euler number).
`static Field<java.lang.String>`	`escape(Field<java.lang.String> field, char escape)` Convenience method for `replace(Field, String, String)` to escape data for use with `Field.like(Field, char)`.
`static java.lang.String`	`escape(java.lang.String value, char escape)` Convenience method for `replace(Field, String, String)` to escape data for use with `Field.like(Field, char)`.
`static AggregateFunction<java.lang.Boolean>`	`every(Condition condition)` Get the every value over a condition: every(condition).
`static AggregateFunction<java.lang.Boolean>`	`every(Field<java.lang.Boolean> field)` Get the every value over a field: every(field).
`static Condition`	`exists(Select<?> query)` Create an exists condition.
`static Field<java.math.BigDecimal>`	`exp(Field<? extends java.lang.Number> field)` Get the exp(field) function, taking this field as the power of e.
`static Field<java.math.BigDecimal>`	`exp(java.lang.Number value)` Get the exp(field) function, taking this field as the power of e.
`static Field<java.lang.Integer>`	`extract(java.util.Date value, DatePart datePart)` Get the extract(field, datePart) function.
`static Field<java.lang.Integer>`	`extract(Field<? extends java.util.Date> field, DatePart datePart)` Get the extract(field, datePart) function.
`static Condition`	`falseCondition()` Return a `Condition` that will always evaluate to false.
`static Field<java.lang.Boolean>`	`field(Condition condition)` Transform a condition into a boolean field.
`static Field<java.lang.Object>`	`field(Name name)` Create a qualified field, given its (qualified) field name.
`static <T> Field<T>`	`field(Name name, java.lang.Class<T> type)` Create a qualified field, given its (qualified) field name.
`static <T> Field<T>`	`field(Name name, DataType<T> type)` Create a qualified field, given its (qualified) field name.
`static <T1> Field<Record1<T1>>`	`field(Row1<T1> row)` EXPERIMENTAL: Turn a row value expression of degree `1` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Field<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>`	`field(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)` EXPERIMENTAL: Turn a row value expression of degree `10` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Field<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>`	`field(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> row)` EXPERIMENTAL: Turn a row value expression of degree `11` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Field<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>`	`field(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> row)` EXPERIMENTAL: Turn a row value expression of degree `12` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Field<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>`	`field(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> row)` EXPERIMENTAL: Turn a row value expression of degree `13` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Field<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>`	`field(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> row)` EXPERIMENTAL: Turn a row value expression of degree `14` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Field<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>`	`field(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> row)` EXPERIMENTAL: Turn a row value expression of degree `15` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Field<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>`	`field(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)` EXPERIMENTAL: Turn a row value expression of degree `16` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Field<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>`	`field(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> row)` EXPERIMENTAL: Turn a row value expression of degree `17` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Field<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>`	`field(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)` EXPERIMENTAL: Turn a row value expression of degree `18` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Field<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>`	`field(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)` EXPERIMENTAL: Turn a row value expression of degree `19` into a `Field`.
`static <T1,T2> Field<Record2<T1,T2>>`	`field(Row2<T1,T2> row)` EXPERIMENTAL: Turn a row value expression of degree `2` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Field<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>`	`field(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> row)` EXPERIMENTAL: Turn a row value expression of degree `20` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Field<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>`	`field(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> row)` EXPERIMENTAL: Turn a row value expression of degree `21` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Field<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>`	`field(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> row)` EXPERIMENTAL: Turn a row value expression of degree `22` into a `Field`.
`static <T1,T2,T3> Field<Record3<T1,T2,T3>>`	`field(Row3<T1,T2,T3> row)` EXPERIMENTAL: Turn a row value expression of degree `3` into a `Field`.
`static <T1,T2,T3,T4> Field<Record4<T1,T2,T3,T4>>`	`field(Row4<T1,T2,T3,T4> row)` EXPERIMENTAL: Turn a row value expression of degree `4` into a `Field`.
`static <T1,T2,T3,T4,T5> Field<Record5<T1,T2,T3,T4,T5>>`	`field(Row5<T1,T2,T3,T4,T5> row)` EXPERIMENTAL: Turn a row value expression of degree `5` into a `Field`.
`static <T1,T2,T3,T4,T5,T6> Field<Record6<T1,T2,T3,T4,T5,T6>>`	`field(Row6<T1,T2,T3,T4,T5,T6> row)` EXPERIMENTAL: Turn a row value expression of degree `6` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7> Field<Record7<T1,T2,T3,T4,T5,T6,T7>>`	`field(Row7<T1,T2,T3,T4,T5,T6,T7> row)` EXPERIMENTAL: Turn a row value expression of degree `7` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8> Field<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>`	`field(Row8<T1,T2,T3,T4,T5,T6,T7,T8> row)` EXPERIMENTAL: Turn a row value expression of degree `8` into a `Field`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> Field<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>`	`field(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row)` EXPERIMENTAL: Turn a row value expression of degree `9` into a `Field`.
`static <T> Field<T>`	`field(Select<? extends Record1<T>> select)` Transform a subquery into a correlated subquery.
`static <T> Field<T>`	`field(SelectField<T> field)` Wrap a `SelectField` in a general-purpose `Field`
`static Field<java.lang.Object>`	`field(java.lang.String sql)` Create a "plain SQL" field.
`static <T> Field<T>`	`field(java.lang.String sql, java.lang.Class<T> type)` Create a "plain SQL" field.
`static <T> Field<T>`	`field(java.lang.String sql, java.lang.Class<T> type, java.lang.Object... bindings)` Create a "plain SQL" field.
`static <T> Field<T>`	`field(java.lang.String sql, java.lang.Class<T> type, QueryPart... parts)` A custom SQL clause that can render arbitrary SQL elements.
`static <T> Field<T>`	`field(java.lang.String sql, DataType<T> type)` Create a "plain SQL" field.
`static <T> Field<T>`	`field(java.lang.String sql, DataType<T> type, java.lang.Object... bindings)` Create a "plain SQL" field.
`static Field<java.lang.Object>`	`field(java.lang.String sql, java.lang.Object... bindings)` Create a "plain SQL" field.
`static Field<java.lang.Object>`	`field(java.lang.String sql, QueryPart... parts)` A custom SQL clause that can render arbitrary SQL elements.
`static <T> Field<T>`	`fieldByName(java.lang.Class<T> type, java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `sequence(Name, Class)` instead
`static <T> Field<T>`	`fieldByName(DataType<T> type, java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `sequence(Name, DataType)` instead
`static Field<java.lang.Object>`	`fieldByName(java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `field(Name)` instead
`static <T> WindowIgnoreNullsStep<T>`	`firstValue(Field<T> field)` The `first_value(field) over ([analytic clause])` function.
`static <T extends java.lang.Number> Field<T>`	`floor(Field<T> field)` Get the largest integer value not greater than [this].
`static <T extends java.lang.Number> Field<T>`	`floor(T value)` Get the largest integer value not greater than [this].
`static <T> Field<T>`	`function(Name name, java.lang.Class<T> type, Field<?>... arguments)` `function()` can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
`static <T> Field<T>`	`function(Name name, DataType<T> type, Field<?>... arguments)` `function()` can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
`static <T> Field<T>`	`function(java.lang.String name, java.lang.Class<T> type, Field<?>... arguments)` `function()` can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
`static <T> Field<T>`	`function(java.lang.String name, DataType<T> type, Field<?>... arguments)` `function()` can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
`static Table<Record1<java.lang.Integer>>`	`generateSeries(Field<java.lang.Integer> from, Field<java.lang.Integer> to)` A table function generating a series of values from `from` to `to` (inclusive).
`static Table<Record1<java.lang.Integer>>`	`generateSeries(Field<java.lang.Integer> from, int to)` A table function generating a series of values from `from` to `to` (inclusive).
`static Table<Record1<java.lang.Integer>>`	`generateSeries(int from, Field<java.lang.Integer> to)` A table function generating a series of values from `from` to `to` (inclusive).
`static Table<Record1<java.lang.Integer>>`	`generateSeries(int from, int to)` A table function generating a series of values from `from` to `to` (inclusive).
`static <T> DataType<T>`	`getDataType(java.lang.Class<T> type)` Get the default data type for the `DSLContext`'s underlying `SQLDialect` and a given Java type.
`static <T> Field<T>`	`greatest(Field<T> field, Field<?>... others)` Find the greatest among all values.
`static <T> Field<T>`	`greatest(T value, T... values)` Find the greatest among all values.
`static GroupConcatOrderByStep`	`groupConcat(Field<?> field)` Get the aggregated concatenation for a field.
`static AggregateFunction<java.lang.String>`	`groupConcat(Field<?> field, java.lang.String separator)` Get the aggregated concatenation for a field.
`static GroupConcatOrderByStep`	`groupConcatDistinct(Field<?> field)` Get the aggregated concatenation for a field.
`static Field<java.lang.Integer>`	`grouping(Field<?> field)` Create a GROUPING(field) aggregation field to be used along with `CUBE`, `ROLLUP`, and `GROUPING SETS` groupings.
`static Field<java.lang.Integer>`	`groupingId(Field<?>... fields)` Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be used along with `CUBE`, `ROLLUP`, and `GROUPING SETS` groupings.
`static GroupField`	`groupingSets(java.util.Collection<? extends Field<?>>... fieldSets)` Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
`static GroupField`	`groupingSets(Field<?>... fields)` Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.
`static GroupField`	`groupingSets(Field<?>[]... fieldSets)` Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.
`static Field<java.lang.Integer>`	`hour(java.util.Date value)` Get the hour part of a date.
`static Field<java.lang.Integer>`	`hour(Field<? extends java.util.Date> field)` Get the hour part of a date.
`static Param<java.lang.String>`	`inline(char character)` Create a bind value, that is always inlined.
`static Param<java.lang.String>`	`inline(java.lang.Character character)` Create a bind value, that is always inlined.
`static Param<java.lang.String>`	`inline(java.lang.CharSequence character)` Create a bind value, that is always inlined.
`static <T> Param<T>`	`inline(java.lang.Object value, java.lang.Class<T> type)` Create a bind value, that is always inlined.
`static <T> Param<T>`	`inline(java.lang.Object value, DataType<T> type)` Create a bind value, that is always inlined.
`static <T> Param<T>`	`inline(java.lang.Object value, Field<T> field)` Create a bind value, that is always inlined.
`static <T> Param<T>`	`inline(T value)` Create a bind value, that is always inlined.
`static <R extends Record> InsertSetStep<R>`	`insertInto(Table<R> into)` Create a new DSL insert statement.
`static <R extends Record> InsertValuesStepN<R>`	`insertInto(Table<R> into, java.util.Collection<? extends Field<?>> fields)` Create a new DSL insert statement.
`static <R extends Record> InsertValuesStepN<R>`	`insertInto(Table<R> into, Field<?>... fields)` Create a new DSL insert statement.
`static <R extends Record,T1> InsertValuesStep1<R,T1>`	`insertInto(Table<R> into, Field<T1> field1)` Create a new DSL insert statement.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <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.
`static <T> Field<T>`	`isnull(Field<T> value, Field<T> defaultValue)` Gets the SQL Server-style ISNULL(value, defaultValue) function.
`static <T> Field<T>`	`isnull(Field<T> value, T defaultValue)` Gets the SQL Server-style ISNULL(value, defaultValue) function.
`static <T> Field<T>`	`isnull(T value, Field<T> defaultValue)` Gets the SQL Server-style ISNULL(value, defaultValue) function.
`static <T> Field<T>`	`isnull(T value, T defaultValue)` Gets the SQL Server-style ISNULL(value, defaultValue) function.
`static Keyword`	`keyword(java.lang.String keyword)` Create a SQL keyword.
`static <T> WindowIgnoreNullsStep<T>`	`lag(Field<T> field)` The `lag(field) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lag(Field<T> field, int offset)` The `lag(field, offset) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lag(Field<T> field, int offset, Field<T> defaultValue)` The `lag(field, offset, defaultValue) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lag(Field<T> field, int offset, T defaultValue)` The `lag(field, offset, defaultValue) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lastValue(Field<T> field)` The `last_value(field) over ([analytic clause])` function.
`static <R extends Record> Table<R>`	`lateral(TableLike<R> table)` Create a `LATERAL` joined table.
`static <T> WindowIgnoreNullsStep<T>`	`lead(Field<T> field)` The `lead(field) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lead(Field<T> field, int offset)` The `lead(field, offset) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lead(Field<T> field, int offset, Field<T> defaultValue)` The `lead(field, offset, defaultValue) over ([analytic clause])` function.
`static <T> WindowIgnoreNullsStep<T>`	`lead(Field<T> field, int offset, T defaultValue)` The `lead(field, offset, defaultValue) over ([analytic clause])` function.
`static <T> Field<T>`	`least(Field<T> field, Field<?>... others)` Find the least among all values.
`static <T> Field<T>`	`least(T value, T... values)` Find the least among all values.
`static Field<java.lang.String>`	`left(Field<java.lang.String> field, Field<? extends java.lang.Number> length)` Get the left outermost characters from a string.
`static Field<java.lang.String>`	`left(Field<java.lang.String> field, int length)` Get the left outermost characters from a string.
`static Field<java.lang.String>`	`left(java.lang.String field, Field<? extends java.lang.Number> length)` Get the left outermost characters from a string.
`static Field<java.lang.String>`	`left(java.lang.String field, int length)` Get the left outermost characters from a string.
`static Field<java.lang.Integer>`	`length(Field<java.lang.String> field)` Get the length of a `VARCHAR` type.
`static Field<java.lang.Integer>`	`length(java.lang.String value)` Get the length of a `VARCHAR` type.
`static Field<java.lang.Integer>`	`level()` Retrieve the Oracle-specific `LEVEL` pseudo-field (to be used along with `CONNECT BY` clauses).
`static QueryPart`	`list(java.util.Collection<? extends QueryPart> parts)` Compose a list of `QueryParts` into a new `QueryPart`, with individual parts being comma-separated.
`static QueryPart`	`list(QueryPart... parts)` Compose a list of `QueryParts` into a new `QueryPart`, with individual parts being comma-separated.
`static OrderedAggregateFunction<java.lang.String>`	`listAgg(Field<?> field)` Get the aggregated concatenation for a field.
`static OrderedAggregateFunction<java.lang.String>`	`listAgg(Field<?> field, java.lang.String separator)` Get the aggregated concatenation for a field.
`static Field<java.math.BigDecimal>`	`ln(Field<? extends java.lang.Number> field)` Get the ln(field) function, taking the natural logarithm of this field.
`static Field<java.math.BigDecimal>`	`ln(java.lang.Number value)` Get the ln(field) function, taking the natural logarithm of this field.
`static Field<java.math.BigDecimal>`	`log(Field<? extends java.lang.Number> field, int base)` Get the log(field, base) function.
`static Field<java.math.BigDecimal>`	`log(java.lang.Number value, int base)` Get the log(field, base) function.
`static Field<java.lang.String>`	`lower(Field<java.lang.String> field)` Get the lower(field) function.
`static Field<java.lang.String>`	`lower(java.lang.String value)` Get the lower(field) function.
`static Field<java.lang.String>`	`lpad(Field<java.lang.String> field, Field<? extends java.lang.Number> length)` Get the lpad(field, length) function.
`static Field<java.lang.String>`	`lpad(Field<java.lang.String> field, Field<? extends java.lang.Number> length, Field<java.lang.String> character)` Get the lpad(field, length, character) function.
`static Field<java.lang.String>`	`lpad(Field<java.lang.String> field, int length)` Get the lpad(field, length) function.
`static Field<java.lang.String>`	`lpad(Field<java.lang.String> field, int length, char character)` Get the lpad(field, length, character) function.
`static Field<java.lang.String>`	`lpad(Field<java.lang.String> field, int length, java.lang.String character)` Get the lpad(field, length, character) function.
`static Field<java.lang.String>`	`ltrim(Field<java.lang.String> field)` Get the ltrim(field) function.
`static Field<java.lang.String>`	`ltrim(java.lang.String value)` Get the ltrim(field) function.
`static <T> AggregateFunction<T>`	`max(Field<T> field)` Get the max value over a field: max(field).
`static <T> AggregateFunction<T>`	`maxDistinct(Field<T> field)` Get the max value over a field: max(distinct field).
`static Field<java.lang.String>`	`md5(Field<java.lang.String> string)` Get the MySQL-specific `MD5()` function.
`static Field<java.lang.String>`	`md5(java.lang.String string)` Get the MySQL-specific `MD5()` function.
`static AggregateFunction<java.math.BigDecimal>`	`median(Field<? extends java.lang.Number> field)` Get the median over a numeric field: median(field).
`static <R extends Record> MergeUsingStep<R>`	`mergeInto(Table<R> table)` Create a new DSL SQL standard MERGE statement.
`static <R extends Record> MergeKeyStepN<R>`	`mergeInto(Table<R> table, java.util.Collection<? extends Field<?>> fields)` Create a new DSL merge statement (H2-specific syntax).
`static <R extends Record> MergeKeyStepN<R>`	`mergeInto(Table<R> table, Field<?>... fields)` Create a new DSL merge statement (H2-specific syntax).
`static <R extends Record,T1> MergeKeyStep1<R,T1>`	`mergeInto(Table<R> table, Field<T1> field1)` Create a new DSL merge statement (H2-specific syntax).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static <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).
`static Field<java.lang.String>`	`mid(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition, Field<? extends java.lang.Number> length)` Get the mid(field, startingPosition, length) function.
`static Field<java.lang.String>`	`mid(Field<java.lang.String> field, int startingPosition, int length)` Get the mid(field, startingPosition, length) function.
`static <T> AggregateFunction<T>`	`min(Field<T> field)` Get the min value over a field: min(field).
`static <T> AggregateFunction<T>`	`minDistinct(Field<T> field)` Get the min value over a field: min(distinct field).
`static Field<java.lang.Integer>`	`minute(java.util.Date value)` Get the minute part of a date.
`static Field<java.lang.Integer>`	`minute(Field<? extends java.util.Date> field)` Get the minute part of a date.
`static Field<java.lang.Integer>`	`month(java.util.Date value)` Get the month part of a date.
`static Field<java.lang.Integer>`	`month(Field<? extends java.util.Date> field)` Get the month part of a date.
`static Name`	`name(java.lang.String... qualifiedName)` Create a new SQL identifier using a qualified name.
`static Field<java.lang.Boolean>`	`not(java.lang.Boolean value)` Invert a boolean value.
`static Condition`	`not(Condition condition)` Invert a condition.
`static Field<java.lang.Boolean>`	`not(Field<java.lang.Boolean> field)` Invert a boolean value.
`static Condition`	`notExists(Select<?> query)` Create a not exists condition.
`static WindowOverStep<java.lang.Integer>`	`ntile(int number)` The `ntile([number]) over ([analytic clause])` function.
`static <T> Field<T>`	`nullif(Field<T> value, Field<T> other)` Gets the Oracle-style NULLIF(value, other) function.
`static <T> Field<T>`	`nullif(Field<T> value, T other)` Gets the Oracle-style NULLIF(value, other) function.
`static <T> Field<T>`	`nullif(T value, Field<T> other)` Gets the Oracle-style NULLIF(value, other) function.
`static <T> Field<T>`	`nullif(T value, T other)` Gets the Oracle-style NULLIF(value, other) function.
`protected static Field<?>[]`	`nullSafe(Field<?>... fields)` Null-safety of a field.
`protected static <T> Field<T>`	`nullSafe(Field<T> field)` Null-safety of a field.
`protected static <T> DataType<T>`	`nullSafeDataType(Field<T> field)` Get a default data type if a field is null.
`static <T> Field<T>`	`nvl(Field<T> value, Field<T> defaultValue)` Gets the Oracle-style NVL(value, defaultValue) function.
`static <T> Field<T>`	`nvl(Field<T> value, T defaultValue)` Gets the Oracle-style NVL(value, defaultValue) function.
`static <T> Field<T>`	`nvl(T value, Field<T> defaultValue)` Gets the Oracle-style NVL(value, defaultValue) function.
`static <T> Field<T>`	`nvl(T value, T defaultValue)` Gets the Oracle-style NVL(value, defaultValue) function.
`static <Z> Field<Z>`	`nvl2(Field<?> value, Field<Z> valueIfNotNull, Field<Z> valueIfNull)` Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
`static <Z> Field<Z>`	`nvl2(Field<?> value, Field<Z> valueIfNotNull, Z valueIfNull)` Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
`static <Z> Field<Z>`	`nvl2(Field<?> value, Z valueIfNotNull, Field<Z> valueIfNull)` Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
`static <Z> Field<Z>`	`nvl2(Field<?> value, Z valueIfNotNull, Z valueIfNull)` Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function.
`static Field<java.lang.Integer>`	`octetLength(Field<java.lang.String> field)` Get the octet_length(field) function.
`static Field<java.lang.Integer>`	`octetLength(java.lang.String value)` Get the octet_length(field) function.
`static Field<java.lang.Integer>`	`one()` A `1` literal.
`static Condition`	`or(java.util.Collection<? extends Condition> conditions)` Return a `Condition` that connects all argument `conditions` with `Operator.OR`.
`static Condition`	`or(Condition... conditions)` Return a `Condition` that connects all argument `conditions` with `Operator.OR`.
`static WindowSpecificationRowsStep`	`orderBy(java.util.Collection<? extends SortField<?>> fields)` Create a `WindowSpecification` with an `ORDER BY` clause.
`static WindowSpecificationOrderByStep`	`orderBy(Field<?>... fields)` Create a `WindowSpecification` with an `ORDER BY` clause.
`static WindowSpecificationRowsStep`	`orderBy(SortField<?>... fields)` Create a `WindowSpecification` with an `ORDER BY` clause.
`static <T> Param<java.lang.Object>`	`param()` Create an unnamed parameter with a generic type (`Object` / `SQLDataType.OTHER`) and no initial value.
`static <T> Param<T>`	`param(java.lang.Class<T> type)` Create an unnamed parameter with a defined type and no initial value.
`static <T> Param<T>`	`param(DataType<T> type)` Create an unnamed parameter with a defined type and no initial value.
`static <T> Param<T>`	`param(Field<T> field)` Create an unnamed parameter with the defined type of another field and no initial value.
`static Param<java.lang.Object>`	`param(java.lang.String name)` Create a named parameter with a generic type (`Object` / `SQLDataType.OTHER`) and no initial value.
`static <T> Param<T>`	`param(java.lang.String name, java.lang.Class<T> type)` Create a named parameter with a defined type and no initial value.
`static <T> Param<T>`	`param(java.lang.String name, DataType<T> type)` Create a named parameter with a defined type and no initial value.
`static <T> Param<T>`	`param(java.lang.String name, Field<T> type)` Create a named parameter with a defined type of another field and no initial value.
`static <T> Param<T>`	`param(java.lang.String name, T value)` Create a named parameter with an initial value.
`static WindowSpecificationOrderByStep`	`partitionBy(java.util.Collection<? extends Field<?>> fields)` Create a `WindowSpecification` with a `PARTITION BY` clause.
`static WindowSpecificationOrderByStep`	`partitionBy(Field<?>... fields)` Create a `WindowSpecification` with a `PARTITION BY` clause.
`static OrderedAggregateFunction<java.math.BigDecimal>`	`percentileCont(Field<? extends java.lang.Number> field)` The `percentile_cont([number]) within group (order by [column])` function.
`static OrderedAggregateFunction<java.math.BigDecimal>`	`percentileCont(java.lang.Number number)` The `percentile_cont([number]) within group (order by [column])` function.
`static OrderedAggregateFunction<java.math.BigDecimal>`	`percentileDisc(Field<? extends java.lang.Number> field)` The `percentile_disc([number]) within group (order by [column])` function.
`static OrderedAggregateFunction<java.math.BigDecimal>`	`percentileDisc(java.lang.Number number)` The `percentile_disc([number]) within group (order by [column])` function.
`static WindowOverStep<java.math.BigDecimal>`	`percentRank()` The `precent_rank() over ([analytic clause])` function.
`static OrderedAggregateFunction<java.lang.Integer>`	`percentRank(Field<?>... fields)` The `percent_rank(expr) within group (order by [order clause])` ordered aggregate function.
`static Field<java.math.BigDecimal>`	`pi()` The `PI` literal.
`static Field<java.lang.Integer>`	`position(Field<java.lang.String> in, Field<java.lang.String> search)` Get the position(in, search) function.
`static Field<java.lang.Integer>`	`position(Field<java.lang.String> in, java.lang.String search)` Get the position(in, search) function.
`static Field<java.lang.Integer>`	`position(java.lang.String in, Field<java.lang.String> search)` Get the position(in, search) function.
`static Field<java.lang.Integer>`	`position(java.lang.String in, java.lang.String search)` Get the position(in, search) function.
`static Field<java.math.BigDecimal>`	`power(Field<? extends java.lang.Number> field, Field<? extends java.lang.Number> exponent)` Get the power(field, exponent) function.
`static Field<java.math.BigDecimal>`	`power(Field<? extends java.lang.Number> field, java.lang.Number exponent)` Get the power(field, exponent) function.
`static Field<java.math.BigDecimal>`	`power(java.lang.Number value, Field<? extends java.lang.Number> exponent)` Get the power(field, exponent) function.
`static Field<java.math.BigDecimal>`	`power(java.lang.Number value, java.lang.Number exponent)` Get the power(field, exponent) function.
`static <T> Field<T>`	`prior(Field<T> field)` Add the Oracle-specific `PRIOR` unary operator before a field (to be used along with `CONNECT BY` clauses).
`static Query`	`query(java.lang.String sql)` Create a new query holding plain SQL.
`static Query`	`query(java.lang.String sql, java.lang.Object... bindings)` Create a new query holding plain SQL.
`static Query`	`query(java.lang.String sql, QueryPart... parts)` Create a new query holding plain SQL.
`static QueryPart`	`queryPart(java.lang.String sql)` Deprecated. - 3.6.0 - [#3854] - Use `sql(String)` instead
`static QueryPart`	`queryPart(java.lang.String sql, java.lang.Object... bindings)` Deprecated. - 3.6.0 - [#3854] - Use `sql(String, Object...)` instead
`static QueryPart`	`queryPart(java.lang.String sql, QueryPart... parts)` Deprecated. - 3.6.0 - [#3854] - Use `sql(String, QueryPart...)` instead
`static Field<java.math.BigDecimal>`	`rad(Field<? extends java.lang.Number> field)` Calculate radians from degrees from this field.
`static Field<java.math.BigDecimal>`	`rad(java.lang.Number value)` Calculate radians from degrees from this field.
`static Field<java.math.BigDecimal>`	`rand()` Get the rand() function.
`static WindowOverStep<java.lang.Integer>`	`rank()` The `rank() over ([analytic clause])` function.
`static OrderedAggregateFunction<java.lang.Integer>`	`rank(Field<?>... fields)` The `rank(expr) within group (order by [order clause])` ordered aggregate function.
`static AggregateFunction<java.math.BigDecimal>`	`regrAvgX(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_AVGX` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrAvgY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_AVGY` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrCount(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_COUNT` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrIntercept(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_INTERCEPT` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrR2(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_R2` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrSlope(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_SLOPE` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrSXX(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_SXX` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrSXY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_SXY` linear regression function.
`static AggregateFunction<java.math.BigDecimal>`	`regrSYY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x)` Get the `REGR_SYY` linear regression function.
`static Field<java.lang.String>`	`repeat(Field<java.lang.String> field, Field<? extends java.lang.Number> count)` Get the repeat(field, count) function.
`static Field<java.lang.String>`	`repeat(Field<java.lang.String> field, int count)` Get the repeat(count) function.
`static Field<java.lang.String>`	`repeat(java.lang.String field, Field<? extends java.lang.Number> count)` Get the repeat(field, count) function.
`static Field<java.lang.String>`	`repeat(java.lang.String field, int count)` Get the repeat(field, count) function.
`static Field<java.lang.String>`	`replace(Field<java.lang.String> field, Field<java.lang.String> search)` Get the replace(field, search) function.
`static Field<java.lang.String>`	`replace(Field<java.lang.String> field, Field<java.lang.String> search, Field<java.lang.String> replace)` Get the replace(field, search, replace) function.
`static Field<java.lang.String>`	`replace(Field<java.lang.String> field, java.lang.String search)` Get the replace(field, search) function.
`static Field<java.lang.String>`	`replace(Field<java.lang.String> field, java.lang.String search, java.lang.String replace)` Get the replace(field, search, replace) function.
`static ResultQuery<Record>`	`resultQuery(java.lang.String sql)` Create a new query holding plain SQL.
`static ResultQuery<Record>`	`resultQuery(java.lang.String sql, java.lang.Object... bindings)` Create a new query holding plain SQL.
`static ResultQuery<Record>`	`resultQuery(java.lang.String sql, QueryPart... parts)` Create a new query holding plain SQL.
`static Field<java.lang.String>`	`reverse(Field<java.lang.String> field)` Get the `reverse(field)` function.
`static Field<java.lang.String>`	`reverse(java.lang.String value)` Get the `reverse(field)` function.
`static Field<java.lang.String>`	`right(Field<java.lang.String> field, Field<? extends java.lang.Number> length)` Get the right outermost characters from a string.
`static Field<java.lang.String>`	`right(Field<java.lang.String> field, int length)` Get the right outermost characters from a string.
`static Field<java.lang.String>`	`right(java.lang.String field, Field<? extends java.lang.Number> length)` Get the right outermost characters from a string.
`static Field<java.lang.String>`	`right(java.lang.String field, int length)` Get the right outermost characters from a string.
`static GroupField`	`rollup(Field<?>... fields)` Create a ROLLUP(field1, field2, .., fieldn) grouping field.
`static <T extends java.lang.Number> Field<T>`	`round(Field<T> field)` Get rounded value of a numeric field: round(field).
`static <T extends java.lang.Number> Field<T>`	`round(Field<T> field, int decimals)` Get rounded value of a numeric field: round(field, decimals).
`static <T extends java.lang.Number> Field<T>`	`round(T value)` Get rounded value of a numeric field: round(field).
`static <T extends java.lang.Number> Field<T>`	`round(T value, int decimals)` Get rounded value of a numeric field: round(field, decimals).
`static RowN`	`row(java.util.Collection<?> values)` Create a row value expression of degree `N > 22`.
`static RowN`	`row(Field<?>... values)` Create a row value expression of degree `N > 22`.
`static <T1> Row1<T1>`	`row(Field<T1> t1)` Create a row value expression of degree `1`.
`static <T1,T2> Row2<T1,T2>`	`row(Field<T1> t1, Field<T2> t2)` Create a row value expression of degree `2`.
`static <T1,T2,T3> Row3<T1,T2,T3>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3)` Create a row value expression of degree `3`.
`static <T1,T2,T3,T4> Row4<T1,T2,T3,T4>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4)` Create a row value expression of degree `4`.
`static <T1,T2,T3,T4,T5> Row5<T1,T2,T3,T4,T5>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5)` Create a row value expression of degree `5`.
`static <T1,T2,T3,T4,T5,T6> Row6<T1,T2,T3,T4,T5,T6>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6)` Create a row value expression of degree `6`.
`static <T1,T2,T3,T4,T5,T6,T7> Row7<T1,T2,T3,T4,T5,T6,T7>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7)` Create a row value expression of degree `7`.
`static <T1,T2,T3,T4,T5,T6,T7,T8> Row8<T1,T2,T3,T4,T5,T6,T7,T8>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8)` Create a row value expression of degree `8`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9)` Create a row value expression of degree `9`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)` Create a row value expression of degree `10`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11)` Create a row value expression of degree `11`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12)` Create a row value expression of degree `12`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13)` Create a row value expression of degree `13`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14)` Create a row value expression of degree `14`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15)` Create a row value expression of degree `15`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)` Create a row value expression of degree `16`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17)` Create a row value expression of degree `17`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18)` Create a row value expression of degree `18`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)` Create a row value expression of degree `19`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20)` Create a row value expression of degree `20`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21)` Create a row value expression of degree `21`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>`	`row(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22)` Create a row value expression of degree `22`.
`static RowN`	`row(java.lang.Object... values)` Create a row value expression of degree `N > 22`.
`static <T1> Row1<T1>`	`row(T1 t1)` Create a row value expression of degree `1`.
`static <T1,T2> Row2<T1,T2>`	`row(T1 t1, T2 t2)` Create a row value expression of degree `2`.
`static <T1,T2,T3> Row3<T1,T2,T3>`	`row(T1 t1, T2 t2, T3 t3)` Create a row value expression of degree `3`.
`static <T1,T2,T3,T4> Row4<T1,T2,T3,T4>`	`row(T1 t1, T2 t2, T3 t3, T4 t4)` Create a row value expression of degree `4`.
`static <T1,T2,T3,T4,T5> Row5<T1,T2,T3,T4,T5>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5)` Create a row value expression of degree `5`.
`static <T1,T2,T3,T4,T5,T6> Row6<T1,T2,T3,T4,T5,T6>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6)` Create a row value expression of degree `6`.
`static <T1,T2,T3,T4,T5,T6,T7> Row7<T1,T2,T3,T4,T5,T6,T7>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7)` Create a row value expression of degree `7`.
`static <T1,T2,T3,T4,T5,T6,T7,T8> Row8<T1,T2,T3,T4,T5,T6,T7,T8>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8)` Create a row value expression of degree `8`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9)` Create a row value expression of degree `9`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)` Create a row value expression of degree `10`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11)` Create a row value expression of degree `11`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12)` Create a row value expression of degree `12`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13)` Create a row value expression of degree `13`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14)` Create a row value expression of degree `14`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15)` Create a row value expression of degree `15`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)` Create a row value expression of degree `16`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17)` Create a row value expression of degree `17`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18)` Create a row value expression of degree `18`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)` Create a row value expression of degree `19`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20)` Create a row value expression of degree `20`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21)` Create a row value expression of degree `21`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>`	`row(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21, T22 t22)` Create a row value expression of degree `22`.
`static Field<java.lang.Integer>`	`rownum()` Retrieve the Oracle-specific `ROWNUM` pseudo-field.
`static WindowOverStep<java.lang.Integer>`	`rowNumber()` The `row_number() over ([analytic clause])` function.
`static WindowSpecificationRowsAndStep`	`rowsBetweenCurrentRow()` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationRowsAndStep`	`rowsBetweenFollowing(int number)` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationRowsAndStep`	`rowsBetweenPreceding(int number)` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationRowsAndStep`	`rowsBetweenUnboundedFollowing()` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationRowsAndStep`	`rowsBetweenUnboundedPreceding()` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationFinalStep`	`rowsCurrentRow()` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationFinalStep`	`rowsFollowing(int number)` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationFinalStep`	`rowsPreceding(int number)` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationFinalStep`	`rowsUnboundedFollowing()` Create a `WindowSpecification` with a `ROWS` clause.
`static WindowSpecificationFinalStep`	`rowsUnboundedPreceding()` Create a `WindowSpecification` with a `ROWS` clause.
`static Field<java.lang.String>`	`rpad(Field<java.lang.String> field, Field<? extends java.lang.Number> length)` Get the rpad(field, length) function.
`static Field<java.lang.String>`	`rpad(Field<java.lang.String> field, Field<? extends java.lang.Number> length, Field<java.lang.String> character)` Get the rpad(field, length, character) function.
`static Field<java.lang.String>`	`rpad(Field<java.lang.String> field, int length)` Get the rpad(field, length) function.
`static Field<java.lang.String>`	`rpad(Field<java.lang.String> field, int length, char character)` Get the rpad(field, length, character) function.
`static Field<java.lang.String>`	`rpad(Field<java.lang.String> field, int length, java.lang.String character)` Get the rpad(field, length, character) function.
`static Field<java.lang.String>`	`rtrim(Field<java.lang.String> field)` Get the rtrim(field) function.
`static Field<java.lang.String>`	`rtrim(java.lang.String value)` Get the rtrim(field) function.
`static Schema`	`schema(Name name)` Create a qualified schema, given its schema name.
`static Schema`	`schemaByName(java.lang.String name)` Deprecated. - [#3843] - 3.6.0 - use `schema(Name)` instead
`static Field<java.lang.Integer>`	`second(java.util.Date value)` Get the second part of a date.
`static Field<java.lang.Integer>`	`second(Field<? extends java.util.Date> field)` Get the second part of a date.
`static SelectSelectStep<Record>`	`select(java.util.Collection<? extends SelectField<?>> fields)` Create a new DSL subselect statement.
`static SelectSelectStep<Record>`	`select(SelectField<?>... fields)` Create a new DSL subselect statement.
`static <T1> SelectSelectStep<Record1<T1>>`	`select(SelectField<T1> field1)` Create a new DSL subselect statement.
`static <T1,T2> SelectSelectStep<Record2<T1,T2>>`	`select(SelectField<T1> field1, SelectField<T2> field2)` Create a new DSL subselect statement.
`static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>`	`select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Create a new DSL subselect statement.
`static SelectSelectStep<Record1<java.lang.Integer>>`	`selectCount()` Create a new DSL subselect statement for `COUNT(*)`.
`static SelectSelectStep<Record>`	`selectDistinct(java.util.Collection<? extends SelectField<?>> fields)` Create a new DSL subselect statement.
`static SelectSelectStep<Record>`	`selectDistinct(SelectField<?>... fields)` Create a new DSL subselect statement.
`static <T1> SelectSelectStep<Record1<T1>>`	`selectDistinct(SelectField<T1> field1)` Create a new DSL subselect statement.
`static <T1,T2> SelectSelectStep<Record2<T1,T2>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2)` Create a new DSL subselect statement.
`static <T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4> SelectSelectStep<Record4<T1,T2,T3,T4>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5> SelectSelectStep<Record5<T1,T2,T3,T4,T5>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6> SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7> SelectSelectStep<Record7<T1,T2,T3,T4,T5,T6,T7>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)` Create a new DSL subselect statement.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>`	`selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)` Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21) Create a new DSL subselect statement.
`static <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(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22) Create a new DSL subselect statement.
`static <R extends Record> SelectWhereStep<R>`	`selectFrom(Table<R> table)` Create a new DSL select statement.
`static SelectSelectStep<Record1<java.lang.Integer>>`	`selectOne()` Create a new DSL subselect statement for a constant `1` literal.
`static SelectSelectStep<Record1<java.lang.Integer>>`	`selectZero()` Create a new DSL subselect statement for a constant `0` literal.
`static Sequence<java.math.BigInteger>`	`sequence(Name name)` Create a qualified sequence, given its sequence name.
`static <T extends java.lang.Number> Sequence<T>`	`sequence(Name name, java.lang.Class<T> type)` Create a qualified sequence, given its sequence name.
`static <T extends java.lang.Number> Sequence<T>`	`sequence(Name name, DataType<T> type)` Create a qualified sequence, given its sequence name.
`static Sequence<java.math.BigInteger>`	`sequence(java.lang.String sql)` Create a "plain SQL" sequence.
`static <T extends java.lang.Number> Sequence<T>`	`sequence(java.lang.String sql, java.lang.Class<T> type)` Create a "plain SQL" sequence.
`static <T extends java.lang.Number> Sequence<T>`	`sequence(java.lang.String sql, DataType<T> type)` Create a "plain SQL" sequence.
`static <T extends java.lang.Number> Sequence<T>`	`sequenceByName(java.lang.Class<T> type, java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `sequence(Name, Class)` instead
`static <T extends java.lang.Number> Sequence<T>`	`sequenceByName(DataType<T> type, java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `sequence(Name, DataType)` instead
`static Sequence<java.math.BigInteger>`	`sequenceByName(java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `sequence(Name)` instead
`static <T extends java.lang.Number> Field<T>`	`shl(Field<T> field1, Field<T> field2)` The bitwise left shift operator.
`static <T extends java.lang.Number> Field<T>`	`shl(Field<T> value1, T value2)` The bitwise left shift operator.
`static <T extends java.lang.Number> Field<T>`	`shl(T value1, Field<T> value2)` The bitwise left shift operator.
`static <T extends java.lang.Number> Field<T>`	`shl(T value1, T value2)` The bitwise left shift operator.
`static <T extends java.lang.Number> Field<T>`	`shr(Field<T> field1, Field<T> field2)` The bitwise right shift operator.
`static <T extends java.lang.Number> Field<T>`	`shr(Field<T> value1, T value2)` The bitwise right shift operator.
`static <T extends java.lang.Number> Field<T>`	`shr(T value1, Field<T> value2)` The bitwise right shift operator.
`static <T extends java.lang.Number> Field<T>`	`shr(T value1, T value2)` The bitwise right shift operator.
`static Field<java.lang.Integer>`	`sign(Field<? extends java.lang.Number> field)` Get the sign of a numeric field: sign(field).
`static Field<java.lang.Integer>`	`sign(java.lang.Number value)` Get the sign of a numeric field: sign(field).
`static Field<java.math.BigDecimal>`	`sin(Field<? extends java.lang.Number> field)` Get the sine(field) function.
`static Field<java.math.BigDecimal>`	`sin(java.lang.Number value)` Get the sine(field) function.
`static Field<java.math.BigDecimal>`	`sinh(Field<? extends java.lang.Number> field)` Get the hyperbolic sine function: sinh(field).
`static Field<java.math.BigDecimal>`	`sinh(java.lang.Number value)` Get the hyperbolic sine function: sinh(field).
`static Field<java.lang.String>`	`space(Field<java.lang.Integer> value)` Get the SQL Server specific `SPACE()` function.
`static Field<java.lang.String>`	`space(int value)` Get the SQL Server specific `SPACE()` function.
`static SQL`	`sql(java.lang.String sql)` A custom SQL clause that can render arbitrary expressions.
`static SQL`	`sql(java.lang.String sql, java.lang.Object... bindings)` A custom SQL clause that can render arbitrary expressions.
`static SQL`	`sql(java.lang.String sql, QueryPart... parts)` A custom SQL clause that can render arbitrary expressions.
`static Field<java.math.BigDecimal>`	`sqrt(Field<? extends java.lang.Number> field)` Get the sqrt(field) function.
`static Field<java.math.BigDecimal>`	`sqrt(java.lang.Number value)` Get the sqrt(field) function.
`static AggregateFunction<java.math.BigDecimal>`	`stddevPop(Field<? extends java.lang.Number> field)` Get the population standard deviation of a numeric field: stddev_pop(field).
`static AggregateFunction<java.math.BigDecimal>`	`stddevSamp(Field<? extends java.lang.Number> field)` Get the sample standard deviation of a numeric field: stddev_samp(field).
`static Field<java.lang.String>`	`substring(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition)` Get the substring(field, startingPosition) function.
`static Field<java.lang.String>`	`substring(Field<java.lang.String> field, Field<? extends java.lang.Number> startingPosition, Field<? extends java.lang.Number> length)` Get the substring(field, startingPosition, length) function.
`static Field<java.lang.String>`	`substring(Field<java.lang.String> field, int startingPosition)` Get the substring(field, startingPosition) function.
`static Field<java.lang.String>`	`substring(Field<java.lang.String> field, int startingPosition, int length)` Get the substring(field, startingPosition, length) function.
`static AggregateFunction<java.math.BigDecimal>`	`sum(Field<? extends java.lang.Number> field)` Get the sum over a numeric field: sum(field).
`static AggregateFunction<java.math.BigDecimal>`	`sumDistinct(Field<? extends java.lang.Number> field)` Get the sum over a numeric field: sum(distinct field).
`static Field<java.lang.String>`	`sysConnectByPath(Field<?> field, java.lang.String separator)` Retrieve the Oracle-specific `SYS_CONNECT_BY_PATH(field, separator)` function (to be used along with `CONNECT BY` clauses).
`static Table<?>`	`table(ArrayRecord<?> array)` A synonym for `unnest(ArrayRecord)`.
`static Table<?>`	`table(Field<?> cursor)` A synonym for `unnest(Field)`.
`static Table<?>`	`table(java.util.List<?> list)` A synonym for `unnest(List)`.
`static Table<Record>`	`table(Name name)` Create a qualified table, given its table name.
`static Table<?>`	`table(java.lang.Object[] array)` A synonym for `unnest(Object[])`.
`static <R extends Record> Table<R>`	`table(R... records)` Use a previously obtained set of records as a new Table
`static <R extends Record> Table<R>`	`table(R record)` Use a previously obtained record as a new Table
`static <R extends Record> Table<R>`	`table(Result<R> result)` Use a previously obtained result as a new `Table` that can be used in SQL statements through `values(RowN...)`.
`static <R extends Record> Table<R>`	`table(Select<R> select)` A synonym for `TableLike.asTable()`, which might look a bit more fluent like this, to some users.
`static Table<Record>`	`table(java.lang.String sql)` A custom SQL clause that can render arbitrary table expressions.
`static Table<Record>`	`table(java.lang.String sql, java.lang.Object... bindings)` A custom SQL clause that can render arbitrary table expressions.
`static Table<Record>`	`table(java.lang.String sql, QueryPart... parts)` A custom SQL clause that can render arbitrary table expressions.
`static Table<Record>`	`tableByName(java.lang.String... qualifiedName)` Deprecated. - [#3843] - 3.6.0 - use `table(Name)` instead
`static Field<java.math.BigDecimal>`	`tan(Field<? extends java.lang.Number> field)` Get the tangent(field) function.
`static Field<java.math.BigDecimal>`	`tan(java.lang.Number value)` Get the tangent(field) function.
`static Field<java.math.BigDecimal>`	`tanh(Field<? extends java.lang.Number> field)` Get the hyperbolic tangent function: tanh(field).
`static Field<java.math.BigDecimal>`	`tanh(java.lang.Number value)` Get the hyperbolic tangent function: tanh(field).
`static Field<java.sql.Time>`	`time(java.util.Date value)` Convert a temporal value to a `TIME`.
`static Field<java.sql.Time>`	`time(Field<? extends java.util.Date> field)` Convert a temporal value to a `TIME`.
`static Field<java.sql.Time>`	`time(java.lang.String value)` Convert a string value to a `TIME`.
`static Field<java.sql.Timestamp>`	`timestamp(java.util.Date value)` Convert a temporal value to a `TIMESTAMP`.
`static Field<java.sql.Timestamp>`	`timestamp(Field<? extends java.util.Date> field)` Convert a temporal value to a `TIMESTAMP`.
`static Field<java.sql.Timestamp>`	`timestamp(java.lang.String value)` Convert a string value to a `TIMESTAMP`.
`static Field<java.sql.Timestamp>`	`timestampAdd(Field<java.sql.Timestamp> timestamp, Field<? extends java.lang.Number> interval)` Add an interval to a timestamp.
`static Field<java.sql.Timestamp>`	`timestampAdd(Field<java.sql.Timestamp> date, Field<? extends java.lang.Number> interval, DatePart datePart)` Add an interval to a timestamp, given a date part.
`static Field<java.sql.Timestamp>`	`timestampAdd(Field<java.sql.Timestamp> date, java.lang.Number interval, DatePart datePart)` Add an interval to a timestamp, given a date part.
`static Field<java.sql.Timestamp>`	`timestampAdd(java.sql.Timestamp date, Field<? extends java.lang.Number> interval, DatePart datePart)` Add an interval to a timestamp, given a date part.
`static Field<java.sql.Timestamp>`	`timestampAdd(java.sql.Timestamp timestamp, java.lang.Number interval)` Add an interval to a timestamp.
`static Field<java.sql.Timestamp>`	`timestampAdd(java.sql.Timestamp date, java.lang.Number interval, DatePart datePart)` Add an interval to a timestamp, given a date part.
`static Field<DayToSecond>`	`timestampDiff(Field<java.sql.Timestamp> timestamp1, Field<java.sql.Timestamp> timestamp2)` Get the timestamp difference as a `INTERVAL DAY TO SECOND` type.
`static Field<DayToSecond>`	`timestampDiff(Field<java.sql.Timestamp> timestamp1, java.sql.Timestamp timestamp2)` Get the timestamp difference as a `INTERVAL DAY TO SECOND` type.
`static Field<DayToSecond>`	`timestampDiff(java.sql.Timestamp timestamp1, Field<java.sql.Timestamp> timestamp2)` Get the timestamp difference as a `INTERVAL DAY TO SECOND` type.
`static Field<DayToSecond>`	`timestampDiff(java.sql.Timestamp timestamp1, java.sql.Timestamp timestamp2)` Get the timestamp difference as a `INTERVAL DAY TO SECOND` type.
`static Field<java.lang.String>`	`trim(Field<java.lang.String> field)` Get the trim(field) function.
`static Field<java.lang.String>`	`trim(java.lang.String value)` Get the trim(field) function.
`static Condition`	`trueCondition()` Return a `Condition` that will always evaluate to true.
`static Field<java.sql.Date>`	`trunc(java.sql.Date date)` Truncate a date to the beginning of the day.
`static Field<java.sql.Date>`	`trunc(java.sql.Date date, DatePart part)` Truncate a date to a given datepart.
`static <T extends java.util.Date> Field<T>`	`trunc(Field<T> date)` Truncate a date or a timestamp to the beginning of the day.
`static <T extends java.util.Date> Field<T>`	`trunc(Field<T> date, DatePart part)` Truncate a date or a timestamp to a given datepart.
`static <T extends java.lang.Number> Field<T>`	`trunc(Field<T> number, Field<java.lang.Integer> decimals)` Truncate a number to a given number of decimals.
`static <T extends java.lang.Number> Field<T>`	`trunc(Field<T> number, int decimals)` Truncate a number to a given number of decimals.
`static <T extends java.lang.Number> Field<T>`	`trunc(T number)` Truncate a number to a given number of decimals.
`static <T extends java.lang.Number> Field<T>`	`trunc(T number, Field<java.lang.Integer> decimals)` Truncate a number to a given number of decimals.
`static Field<java.sql.Timestamp>`	`trunc(java.sql.Timestamp timestamp)` Truncate a timestamp to the beginning of the day.
`static Field<java.sql.Timestamp>`	`trunc(java.sql.Timestamp timestamp, DatePart part)` Truncate a timestamp to a given datepart.
`static <T extends java.lang.Number> Field<T>`	`trunc(T number, int decimals)` Truncate a number to a given number of decimals.
`static TruncateIdentityStep<Record>`	`truncate(Name table)` Create a new DSL truncate statement.
`static <R extends Record> TruncateIdentityStep<R>`	`truncate(Table<R> table)` Create a new DSL truncate statement.
`static Field<java.lang.Integer>`	`two()` A `2` literal.
`static Table<?>`	`unnest(ArrayRecord<?> array)` Create a table from an array of values.
`static Table<?>`	`unnest(Field<?> cursor)` Create a table from a field.
`static Table<?>`	`unnest(java.util.List<?> list)` Create a table from a list of values.
`static Table<?>`	`unnest(java.lang.Object[] array)` Create a table from an array of values.
`static <R extends Record> UpdateSetFirstStep<R>`	`update(Table<R> table)` Create a new DSL update statement.
`static Field<java.lang.String>`	`upper(Field<java.lang.String> field)` Get the upper(field) function.
`static Field<java.lang.String>`	`upper(java.lang.String value)` Get the upper(field) function.
`static DSLContext`	`using(Configuration configuration)` Create an executor from a custom configuration.
`static DSLContext`	`using(java.sql.Connection connection)` Create an executor with a connection configured.
`static DSLContext`	`using(ConnectionProvider connectionProvider, SQLDialect dialect)` Create an executor with a custom connection provider and a dialect configured.
`static DSLContext`	`using(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)` Create an executor with a custom connection provider, a dialect and settings configured.
`static DSLContext`	`using(java.sql.Connection connection, Settings settings)` Create an executor with a connection, a dialect and settings configured.
`static DSLContext`	`using(java.sql.Connection connection, SQLDialect dialect)` Create an executor with a connection and a dialect configured.
`static DSLContext`	`using(java.sql.Connection connection, SQLDialect dialect, Settings settings)` Create an executor with a connection, a dialect and settings configured.
`static DSLContext`	`using(javax.sql.DataSource datasource, SQLDialect dialect)` Create an executor with a data source and a dialect configured.
`static DSLContext`	`using(javax.sql.DataSource datasource, SQLDialect dialect, Settings settings)` Create an executor with a data source, a dialect and settings configured.
`static DSLContext`	`using(SQLDialect dialect)` Create an executor with a dialect configured.
`static DSLContext`	`using(SQLDialect dialect, Settings settings)` Create an executor with a dialect and settings configured.
`static DSLContext`	`using(java.lang.String url)` Create an executor from a JDBC connection URL.
`static DSLContext`	`using(java.lang.String url, java.util.Properties properties)` Create an executor from a JDBC connection URL.
`static DSLContext`	`using(java.lang.String url, java.lang.String username, java.lang.String password)` Create an executor from a JDBC connection URL.
`static <T> Param<T>`	`val(java.lang.Object value, java.lang.Class<T> type)` Get a bind value with an associated type, taken from a field.
`static <T> Param<T>`	`val(java.lang.Object value, DataType<T> type)` Get a bind value with an associated type.
`static <T> Param<T>`	`val(java.lang.Object value, Field<T> field)` Get a bind value with an associated type, taken from a field.
`static <T> Param<T>`	`val(T value)` Get a bind value.
`static <T> Param<T>`	`value(java.lang.Object value, java.lang.Class<T> type)` A synonym for `val(Object, Class)` to be used in Scala and Groovy, where `val` is a reserved keyword.
`static <T> Param<T>`	`value(java.lang.Object value, DataType<T> type)` A synonym for `val(Object, DataType)` to be used in Scala and Groovy, where `val` is a reserved keyword.
`static <T> Param<T>`	`value(java.lang.Object value, Field<T> field)` A synonym for `val(Object, Field)` to be used in Scala and Groovy, where `val` is a reserved keyword.
`static <T> Param<T>`	`value(T value)` A synonym for `val(Object)` to be used in Scala and Groovy, where `val` is a reserved keyword.
`static <T1> Table<Record1<T1>>`	`values(Row1<T1>... rows)` Create a `VALUES()` expression of degree `1`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Table<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>`	`values(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)` Create a `VALUES()` expression of degree `10`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Table<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>`	`values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... rows)` Create a `VALUES()` expression of degree `11`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Table<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>`	`values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows)` Create a `VALUES()` expression of degree `12`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Table<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>`	`values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows)` Create a `VALUES()` expression of degree `13`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Table<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>`	`values(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>... rows)` Create a `VALUES()` expression of degree `14`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Table<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>`	`values(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>... rows)` Create a `VALUES()` expression of degree `15`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Table<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>`	`values(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)` Create a `VALUES()` expression of degree `16`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Table<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>`	`values(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>... rows)` Create a `VALUES()` expression of degree `17`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Table<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>`	`values(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)` Create a `VALUES()` expression of degree `18`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Table<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>`	`values(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)` Create a `VALUES()` expression of degree `19`.
`static <T1,T2> Table<Record2<T1,T2>>`	`values(Row2<T1,T2>... rows)` Create a `VALUES()` expression of degree `2`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Table<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>`	`values(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>... rows)` Create a `VALUES()` expression of degree `20`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Table<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>`	`values(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>... rows)` Create a `VALUES()` expression of degree `21`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Table<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>`	`values(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>... rows)` Create a `VALUES()` expression of degree `22`.
`static <T1,T2,T3> Table<Record3<T1,T2,T3>>`	`values(Row3<T1,T2,T3>... rows)` Create a `VALUES()` expression of degree `3`.
`static <T1,T2,T3,T4> Table<Record4<T1,T2,T3,T4>>`	`values(Row4<T1,T2,T3,T4>... rows)` Create a `VALUES()` expression of degree `4`.
`static <T1,T2,T3,T4,T5> Table<Record5<T1,T2,T3,T4,T5>>`	`values(Row5<T1,T2,T3,T4,T5>... rows)` Create a `VALUES()` expression of degree `5`.
`static <T1,T2,T3,T4,T5,T6> Table<Record6<T1,T2,T3,T4,T5,T6>>`	`values(Row6<T1,T2,T3,T4,T5,T6>... rows)` Create a `VALUES()` expression of degree `6`.
`static <T1,T2,T3,T4,T5,T6,T7> Table<Record7<T1,T2,T3,T4,T5,T6,T7>>`	`values(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)` Create a `VALUES()` expression of degree `7`.
`static <T1,T2,T3,T4,T5,T6,T7,T8> Table<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>`	`values(Row8<T1,T2,T3,T4,T5,T6,T7,T8>... rows)` Create a `VALUES()` expression of degree `8`.
`static <T1,T2,T3,T4,T5,T6,T7,T8,T9> Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>`	`values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)` Create a `VALUES()` expression of degree `9`.
`static Table<Record>`	`values(RowN... rows)` Create a `VALUES()` expression of arbitrary degree.
`static AggregateFunction<java.math.BigDecimal>`	`varPop(Field<? extends java.lang.Number> field)` Get the population variance of a numeric field: var_pop(field).
`static AggregateFunction<java.math.BigDecimal>`	`varSamp(Field<? extends java.lang.Number> field)` Get the sample variance of a numeric field: var_samp(field).
`static <T> CaseConditionStep<T>`	`when(Condition condition, Field<T> result)` Initialise a `Case` statement.
`static <T> CaseConditionStep<T>`	`when(Condition condition, Select<? extends Record1<T>> result)` Initialise a `Case` statement.
`static <T> CaseConditionStep<T>`	`when(Condition condition, T result)` Initialise a `Case` statement.
`static WithStep`	`with(CommonTableExpression<?>... tables)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static WithAsStep`	`with(java.lang.String alias)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static WithAsStep`	`with(java.lang.String alias, java.lang.String... fieldAliases)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static WithStep`	`withRecursive(CommonTableExpression<?>... tables)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static WithAsStep`	`withRecursive(java.lang.String alias)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static WithAsStep`	`withRecursive(java.lang.String alias, java.lang.String... fieldAliases)` Create a `WITH` clause to supply subsequent `SELECT`, `UPDATE`, `INSERT`, `DELETE`, and `MERGE` statements with `CommonTableExpression`s.
`static Field<java.lang.Integer>`	`year(java.util.Date value)` Get the year part of a date.
`static Field<java.lang.Integer>`	`year(Field<? extends java.util.Date> field)` Get the year part of a date.
`static Field<java.lang.Integer>`	`zero()` A `0` literal.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail
- DSL
```
protected DSL()
```
  No instances.

Method Detail

using
```
public static DSLContext using(SQLDialect dialect)
```
Create an executor with a dialect configured.
Without a connection or data source, this executor cannot execute queries. Use it to render SQL only.

Parameters:

dialect - The dialect to use with objects created from this executor

using
```
public static DSLContext using(SQLDialect dialect,
                               Settings settings)
```
Create an executor with a dialect and settings configured.
Without a connection or data source, this executor cannot execute queries. Use it to render SQL only.

Parameters:

dialect - The dialect to use with objects created from this executor

settings - The runtime settings to apply to objects created from this executor

using
```
public static DSLContext using(java.lang.String url)
```
Create an executor from a JDBC connection URL.
The connections created this way will be closed upon finalization. This is useful for standalone scripts, but not for managed connections.

Parameters:

url - The connection URL.

See Also:

DefaultConnectionProvider, JDBCUtils.dialect(String)

using
```
public static DSLContext using(java.lang.String url,
                               java.lang.String username,
                               java.lang.String password)
```
Create an executor from a JDBC connection URL.
The connections created this way will be closed upon finalization. This is useful for standalone scripts, but not for managed connections.

Parameters:

url - The connection URL.

username - The connection user name.

password - The connection password.

See Also:

DefaultConnectionProvider, JDBCUtils.dialect(String)

using
```
public static DSLContext using(java.lang.String url,
                               java.util.Properties properties)
```
Create an executor from a JDBC connection URL.
The connections created this way will be closed upon finalization. This is useful for standalone scripts, but not for managed connections.

Parameters:

url - The connection URL.

properties - The connection properties.

See Also:

DefaultConnectionProvider, JDBCUtils.dialect(String)

using
```
public static DSLContext using(java.sql.Connection connection)
```
Create an executor with a connection configured.
If you provide a JDBC connection to a jOOQ Configuration, jOOQ will use that connection directly for creating statements.
This is a convenience constructor for using(Connection, Settings), guessing the SQLDialect using JDBCUtils.dialect(Connection)

Parameters:

connection - The connection to use with objects created from this executor

See Also:

DefaultConnectionProvider, JDBCUtils.dialect(Connection)

using
```
public static DSLContext using(java.sql.Connection connection,
                               SQLDialect dialect)
```
Create an executor with a connection and a dialect configured.
If you provide a JDBC connection to a jOOQ Configuration, jOOQ will use that connection directly for creating statements.
This is a convenience constructor for using(ConnectionProvider, SQLDialect, Settings) using a DefaultConnectionProvider

Parameters:

connection - The connection to use with objects created from this executor

dialect - The dialect to use with objects created from this executor

See Also:

DefaultConnectionProvider

using
```
public static DSLContext using(java.sql.Connection connection,
                               Settings settings)
```
Create an executor with a connection, a dialect and settings configured.
If you provide a JDBC connection to a jOOQ Configuration, jOOQ will use that connection directly for creating statements.
This is a convenience constructor for using(ConnectionProvider, SQLDialect, Settings) using a DefaultConnectionProvider and guessing the SQLDialect using JDBCUtils.dialect(Connection)

Parameters:

connection - The connection to use with objects created from this executor

settings - The runtime settings to apply to objects created from this executor

See Also:

DefaultConnectionProvider, JDBCUtils.dialect(Connection)

using
```
public static DSLContext using(java.sql.Connection connection,
                               SQLDialect dialect,
                               Settings settings)
```
Create an executor with a connection, a dialect and settings configured.
If you provide a JDBC connection to a jOOQ Configuration, jOOQ will use that connection directly for creating statements.
This is a convenience constructor for using(ConnectionProvider, SQLDialect, Settings) using a DefaultConnectionProvider

Parameters:

connection - The connection to use with objects created from this executor

dialect - The dialect to use with objects created from this executor

settings - The runtime settings to apply to objects created from this executor

See Also:

DefaultConnectionProvider

using
```
public static DSLContext using(javax.sql.DataSource datasource,
                               SQLDialect dialect)
```
Create an executor with a data source and a dialect configured.
If you provide a JDBC data source to a jOOQ Configuration, jOOQ will use that data source for initialising connections, and creating statements.
This is a convenience constructor for using(ConnectionProvider, SQLDialect) using a DataSourceConnectionProvider

Parameters:

datasource - The data source to use with objects created from this executor

dialect - The dialect to use with objects created from this executor

See Also:

DataSourceConnectionProvider

using
```
public static DSLContext using(javax.sql.DataSource datasource,
                               SQLDialect dialect,
                               Settings settings)
```
Create an executor with a data source, a dialect and settings configured.
If you provide a JDBC data source to a jOOQ Configuration, jOOQ will use that data source for initialising connections, and creating statements.
This is a convenience constructor for using(ConnectionProvider, SQLDialect, Settings) using a DataSourceConnectionProvider

Parameters:

datasource - The data source to use with objects created from this executor

dialect - The dialect to use with objects created from this executor

settings - The runtime settings to apply to objects created from this executor

See Also:

DataSourceConnectionProvider

using
```
public static DSLContext using(ConnectionProvider connectionProvider,
                               SQLDialect dialect)
```
Create an executor with a custom connection provider and a dialect configured.

Parameters:

connectionProvider - The connection provider providing jOOQ with JDBC connections

dialect - The dialect to use with objects created from this executor

using
```
public static DSLContext using(ConnectionProvider connectionProvider,
                               SQLDialect dialect,
                               Settings settings)
```
Create an executor with a custom connection provider, a dialect and settings configured.

Parameters:

connectionProvider - The connection provider providing jOOQ with JDBC connections

dialect - The dialect to use with objects created from this executor

settings - The runtime settings to apply to objects created from this executor

using
```
public static DSLContext using(Configuration configuration)
```
Create an executor from a custom configuration.

Parameters:

configuration - The configuration

with
```
@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithAsStep with(java.lang.String alias)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(String) for strictly non-recursive CTE and withRecursive(String) for strictly recursive CTE.

with
```
@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithAsStep with(java.lang.String alias,
                                                                                                      java.lang.String... fieldAliases)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(String, String...) for strictly non-recursive CTE and withRecursive(String, String...) for strictly recursive CTE.

with
```
@Support(value={DB2,FIREBIRD,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithStep with(CommonTableExpression<?>... tables)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
Reusable CommonTableExpression types can be constructed through
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(CommonTableExpression...) for strictly non-recursive CTE and withRecursive(CommonTableExpression...) for strictly recursive CTE.

withRecursive
```
@Support(value={DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithAsStep withRecursive(java.lang.String alias)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(String) for strictly non-recursive CTE and withRecursive(String) for strictly recursive CTE.
Note that the SQLDialect.H2 database only supports single-table, RECURSIVE common table expression lists.

withRecursive
```
@Support(value={DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithAsStep withRecursive(java.lang.String alias,
                                                                                                                  java.lang.String... fieldAliases)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(String, String...) for strictly non-recursive CTE and withRecursive(String, String...) for strictly recursive CTE.
Note that the SQLDialect.H2 database only supports single-table, RECURSIVE common table expression lists.

withRecursive
```
@Support(value={DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
public static WithStep withRecursive(CommonTableExpression<?>... tables)
```
Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
Reusable CommonTableExpression types can be constructed through
The RECURSIVE keyword may be optional or unsupported in some databases, in case of which it will not be rendered. For optimal database interoperability and readability, however, it is suggested that you use with(CommonTableExpression...) for strictly non-recursive CTE and withRecursive(CommonTableExpression...) for strictly recursive CTE.
Note that the SQLDialect.H2 database only supports single-table, RECURSIVE common table expression lists.

selectFrom
```
@Support
public static <R extends Record> SelectWhereStep<R> selectFrom(Table<R> table)
```
Create a new DSL select statement.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
 
```

select
```
@Support
public static SelectSelectStep<Record> select(java.util.Collection<? extends SelectField<?>> fields)
```
Create a new DSL subselect statement.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 select(fields)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.select(Collection)

select
```
@Support
public static SelectSelectStep<Record> select(SelectField<?>... fields)
```
Create a new DSL subselect statement.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.select(SelectField...)

select
```
@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1> SelectSelectStep<Record1<T1>> select(SelectField<T1> field1)
```
Create a new DSL subselect 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.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, field4, field5)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field5, field6)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field6, field7)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> select(SelectField<T1> field1,
                                                                                                                                                                             SelectField<T2> field2,
                                                                                                                                                                             SelectField<T3> field3,
                                                                                                                                                                             SelectField<T4> field4,
                                                                                                                                                                             SelectField<T5> field5,
                                                                                                                                                                             SelectField<T6> field6,
                                                                                                                                                                             SelectField<T7> field7,
                                                                                                                                                                             SelectField<T8> field8)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field7, field8)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select(SelectField<T1> field1,
                                                                                                                                                                                   SelectField<T2> field2,
                                                                                                                                                                                   SelectField<T3> field3,
                                                                                                                                                                                   SelectField<T4> field4,
                                                                                                                                                                                   SelectField<T5> field5,
                                                                                                                                                                                   SelectField<T6> field6,
                                                                                                                                                                                   SelectField<T7> field7,
                                                                                                                                                                                   SelectField<T8> field8,
                                                                                                                                                                                   SelectField<T9> field9)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field8, field9)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select(SelectField<T1> field1,
                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                            SelectField<T10> field10)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field9, field10)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                    SelectField<T11> field11)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field10, field11)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                            SelectField<T12> field12)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field11, field12)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                    SelectField<T13> field13)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field12, field13)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                            SelectField<T14> field14)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field13, field14)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                    SelectField<T15> field15)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field14, field15)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                            SelectField<T16> field16)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field15, field16)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                    SelectField<T17> field17)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field16, field17)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                            SelectField<T17> field17,
                                                                                                                                                                                                                                                            SelectField<T18> field18)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field17, field18)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                                    SelectField<T17> field17,
                                                                                                                                                                                                                                                                    SelectField<T18> field18,
                                                                                                                                                                                                                                                                    SelectField<T19> field19)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field18, field19)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                                            SelectField<T17> field17,
                                                                                                                                                                                                                                                                            SelectField<T18> field18,
                                                                                                                                                                                                                                                                            SelectField<T19> field19,
                                                                                                                                                                                                                                                                            SelectField<T20> field20)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field19, field20)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                                                    SelectField<T17> field17,
                                                                                                                                                                                                                                                                                    SelectField<T18> field18,
                                                                                                                                                                                                                                                                                    SelectField<T19> field19,
                                                                                                                                                                                                                                                                                    SelectField<T20> field20,
                                                                                                                                                                                                                                                                                    SelectField<T21> field21)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field20, field21)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

select

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                                                            SelectField<T17> field17,
                                                                                                                                                                                                                                                                                            SelectField<T18> field18,
                                                                                                                                                                                                                                                                                            SelectField<T19> field19,
                                                                                                                                                                                                                                                                                            SelectField<T20> field20,
                                                                                                                                                                                                                                                                                            SelectField<T21> field21,
                                                                                                                                                                                                                                                                                            SelectField<T22> field22)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 select(field1, field2, field3, .., field21, field22)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);

See Also:: DSLContext.select(SelectField...), select(SelectField...)

selectDistinct
```
@Support
public static SelectSelectStep<Record> selectDistinct(java.util.Collection<? extends SelectField<?>> fields)
```
Create a new DSL subselect statement.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectDistinct(fields)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.selectDistinct(Collection)

selectDistinct
```
@Support
public static SelectSelectStep<Record> selectDistinct(SelectField<?>... fields)
```
Create a new DSL subselect statement.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectDistinct(field1, field2)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.selectDistinct(SelectField...)

selectDistinct
```
@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1> SelectSelectStep<Record1<T1>> selectDistinct(SelectField<T1> field1)
```
Create a new DSL subselect 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.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectDistinct(field1)
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

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

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8> SelectSelectStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> selectDistinct(SelectField<T1> field1,
                                                                                                                                                                                     SelectField<T2> field2,
                                                                                                                                                                                     SelectField<T3> field3,
                                                                                                                                                                                     SelectField<T4> field4,
                                                                                                                                                                                     SelectField<T5> field5,
                                                                                                                                                                                     SelectField<T6> field6,
                                                                                                                                                                                     SelectField<T7> field7,
                                                                                                                                                                                     SelectField<T8> field8)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8,T9> SelectSelectStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> selectDistinct(SelectField<T1> field1,
                                                                                                                                                                                           SelectField<T2> field2,
                                                                                                                                                                                           SelectField<T3> field3,
                                                                                                                                                                                           SelectField<T4> field4,
                                                                                                                                                                                           SelectField<T5> field5,
                                                                                                                                                                                           SelectField<T6> field6,
                                                                                                                                                                                           SelectField<T7> field7,
                                                                                                                                                                                           SelectField<T8> field8,
                                                                                                                                                                                           SelectField<T9> field9)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> SelectSelectStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> selectDistinct(SelectField<T1> field1,
                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                    SelectField<T10> field10)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                            SelectField<T11> field11)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                    SelectField<T12> field12)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                            SelectField<T13> field13)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                    SelectField<T14> field14)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                            SelectField<T15> field15)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                    SelectField<T16> field16)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                            SelectField<T17> field17)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                                    SelectField<T17> field17,
                                                                                                                                                                                                                                                                    SelectField<T18> field18)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                                            SelectField<T17> field17,
                                                                                                                                                                                                                                                                            SelectField<T18> field18,
                                                                                                                                                                                                                                                                            SelectField<T19> field19)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                                                    SelectField<T17> field17,
                                                                                                                                                                                                                                                                                    SelectField<T18> field18,
                                                                                                                                                                                                                                                                                    SelectField<T19> field19,
                                                                                                                                                                                                                                                                                    SelectField<T20> field20)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                                            SelectField<T2> field2,
                                                                                                                                                                                                                                                                                            SelectField<T3> field3,
                                                                                                                                                                                                                                                                                            SelectField<T4> field4,
                                                                                                                                                                                                                                                                                            SelectField<T5> field5,
                                                                                                                                                                                                                                                                                            SelectField<T6> field6,
                                                                                                                                                                                                                                                                                            SelectField<T7> field7,
                                                                                                                                                                                                                                                                                            SelectField<T8> field8,
                                                                                                                                                                                                                                                                                            SelectField<T9> field9,
                                                                                                                                                                                                                                                                                            SelectField<T10> field10,
                                                                                                                                                                                                                                                                                            SelectField<T11> field11,
                                                                                                                                                                                                                                                                                            SelectField<T12> field12,
                                                                                                                                                                                                                                                                                            SelectField<T13> field13,
                                                                                                                                                                                                                                                                                            SelectField<T14> field14,
                                                                                                                                                                                                                                                                                            SelectField<T15> field15,
                                                                                                                                                                                                                                                                                            SelectField<T16> field16,
                                                                                                                                                                                                                                                                                            SelectField<T17> field17,
                                                                                                                                                                                                                                                                                            SelectField<T18> field18,
                                                                                                                                                                                                                                                                                            SelectField<T19> field19,
                                                                                                                                                                                                                                                                                            SelectField<T20> field20,
                                                                                                                                                                                                                                                                                            SelectField<T21> field21)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectDistinct

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <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(SelectField<T1> field1,
                                                                                                                                                                                                                                                                                                    SelectField<T2> field2,
                                                                                                                                                                                                                                                                                                    SelectField<T3> field3,
                                                                                                                                                                                                                                                                                                    SelectField<T4> field4,
                                                                                                                                                                                                                                                                                                    SelectField<T5> field5,
                                                                                                                                                                                                                                                                                                    SelectField<T6> field6,
                                                                                                                                                                                                                                                                                                    SelectField<T7> field7,
                                                                                                                                                                                                                                                                                                    SelectField<T8> field8,
                                                                                                                                                                                                                                                                                                    SelectField<T9> field9,
                                                                                                                                                                                                                                                                                                    SelectField<T10> field10,
                                                                                                                                                                                                                                                                                                    SelectField<T11> field11,
                                                                                                                                                                                                                                                                                                    SelectField<T12> field12,
                                                                                                                                                                                                                                                                                                    SelectField<T13> field13,
                                                                                                                                                                                                                                                                                                    SelectField<T14> field14,
                                                                                                                                                                                                                                                                                                    SelectField<T15> field15,
                                                                                                                                                                                                                                                                                                    SelectField<T16> field16,
                                                                                                                                                                                                                                                                                                    SelectField<T17> field17,
                                                                                                                                                                                                                                                                                                    SelectField<T18> field18,
                                                                                                                                                                                                                                                                                                    SelectField<T19> field19,
                                                                                                                                                                                                                                                                                                    SelectField<T20> field20,
                                                                                                                                                                                                                                                                                                    SelectField<T21> field21,
                                                                                                                                                                                                                                                                                                    SelectField<T22> field22)

Create a new DSL subselect 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.

Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:

As a subselect within another select
As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.selectDistinct(SelectField...), selectDistinct(SelectField...)

selectZero
```
@Support
public static SelectSelectStep<Record1<java.lang.Integer>> selectZero()
```
Create a new DSL subselect statement for a constant 0 literal.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectZero()
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

zero(), DSLContext.selectZero()

selectOne
```
@Support
public static SelectSelectStep<Record1<java.lang.Integer>> selectOne()
```
Create a new DSL subselect statement for a constant 1 literal.
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectOne()
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

one(), DSLContext.selectOne()

selectCount
```
@Support
public static SelectSelectStep<Record1<java.lang.Integer>> selectCount()
```
Create a new DSL subselect statement for COUNT(*).
Unlike Select factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable SELECT statement. You can use this statement in two ways:
- As a subselect within another select
- As a statement, after attaching it using Attachable.attach(org.jooq.Configuration)
Example:
```
 import static org.jooq.impl.DSL.*;

 // [...]

 selectCount()
  .from(table1)
  .join(table2).on(field1.equal(field2))
  .where(field1.greaterThan(100))
  .orderBy(field2);
 
```
See Also:

count(), DSLContext.selectCount()

insertInto

@Support
public static <R extends Record> InsertSetStep<R> insertInto(Table<R> into)

Create a new DSL insert statement.

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable 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:

 import static org.jooq.impl.DSL.*;

 // [...]

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

See Also:: DSLContext.insertInto(Table)

insertInto

@Generated(value="This method was generated using jOOQ-tools")
 @Support
public static <R extends Record,T1> InsertValuesStep1<R,T1> insertInto(Table<R> into,
                                                                                                                                                  Field<T1> field1)

Create a new DSL insert statement.

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 insertInto(table, field1)
   .values(field1)
   .values(field1)
   .onDuplicateKeyUpdate()
   .set(field1, value1)
   .set(field2, value2)

See Also:: DSLContext.insertInto(Table, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 insertInto(table, field1, field2)
   .values(field1, field2)
   .values(field1, field2)
   .onDuplicateKeyUpdate()
   .set(field1, value1)
   .set(field2, value2)

See Also:: DSLContext.insertInto(Table, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 insertInto(table, field1, field2, field3)
   .values(field1, field2, field3)
   .values(field1, field2, field3)
   .onDuplicateKeyUpdate()
   .set(field1, value1)
   .set(field2, value2)

See Also:: DSLContext.insertInto(Table, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 insertInto(table, field1, field2, field3, field4)
   .values(field1, field2, field3, field4)
   .values(field1, field2, field3, field4)
   .onDuplicateKeyUpdate()
   .set(field1, value1)
   .set(field2, value2)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Unlike Insert factory methods in the DSLContext API, this creates an unattached, and thus not directly renderable or executable INSERT statement.

Example:

 import static org.jooq.impl.DSL.*;

 // [...]

 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)

See Also:: DSLContext.insertInto(Table, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field, Field)

insertInto

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

Class DSL

DSL and static imports

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

DSL

Method Detail

using

using

using

using

using

using

using

using

using

using

using

using

using

using

with

with

with

withRecursive

withRecursive

withRecursive

selectFrom

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

select

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectDistinct

selectZero

selectOne

selectCount