Top Description Methods
org.jooq

public non-sealed Interface Table<R extends org.jooq.Record>

extends TableLike<R extends Record>, RecordQualifier<R extends Record>, GroupField, SelectField<R extends Record>
Known Direct Subinterfaces
org.jooq.TableOnConditionStep, org.jooq.TableOptionalOnStep, org.jooq.JSONTableColumnsStep, org.jooq.XMLTableColumnsStep, org.jooq.impl.QOM.HintedTable, org.jooq.impl.QOM.WithOrdinalityTable, org.jooq.impl.QOM.TableAlias, org.jooq.impl.QOM.Dual, org.jooq.impl.QOM.Lateral, org.jooq.impl.QOM.DerivedTable, org.jooq.impl.QOM.Values, org.jooq.impl.QOM.DataChangeDeltaTable, org.jooq.impl.QOM.RowsFrom, org.jooq.impl.QOM.GenerateSeries, org.jooq.impl.QOM.JoinTable, org.jooq.impl.QOM.UEmptyTable, org.jooq.CommonTableExpression
Known Direct Implementers
org.jooq.impl.AbstractTable
Type Parameters
<R>
The record type associated with this table
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB
A table.

Like Field, a Table is a basic building block of any Query, as they all operate on at least one table. There are many different types of tables, including:

Example: 


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

using(configuration)
   .select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME)
   .from(ACTOR) // Table reference
   .fetch();

Instances can be created using DSL#table(Name) and overloads.

Using table references as field expressions

Table references can be used like Field in queries. This includes:

Other types of Table cannot be used this way, even if the type system cannot prevent this.

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull Table<R>

Returns:

The table alias
as(String
The alias name
alias)

Redeclares org.jooq.SelectField.as.

Create an alias for this table.
public @NotNull Table<R>

Returns:

The table alias
as(String
The alias name
alias, String...
The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
fieldAliases)

Create an alias for this table and its fields.

public @NotNull Table<R>

Returns:

The table alias
as(String
The alias name
alias, Collection<? extends String>
The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
fieldAliases)

Create an alias for this table and its fields.

public @NotNull Table<R>

Returns:

The table alias
as(String
The alias name
alias, Function<? super Field<?>, ? extends String>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull Table<R>

Returns:

The table alias
as(String
The alias name
alias, BiFunction<? super Field<?>, ? super Integer, ? extends String>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull Table<R>

Returns:

The table alias
as(Name
The alias name
alias)

Redeclares org.jooq.SelectField.as.

Create an alias for this table.
public @NotNull Table<R>

Returns:

The table alias
as(Name
The alias name
alias, Name...
The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
fieldAliases)

Create an alias for this table and its fields.

public @NotNull Table<R>

Returns:

The table alias
as(Name
The alias name
alias, Collection<? extends Name>
The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
fieldAliases)

Create an alias for this table and its fields.

public @NotNull Table<R>

Returns:

The table alias
as(Name
The alias name
alias, Function<? super Field<?>, ? extends Name>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull Table<R>

Returns:

The table alias
as(Name
The alias name
alias, BiFunction<? super Field<?>, ? super Integer, ? extends Name>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull Table<R>

Returns:

The table alias.
as(Table<?>
The other table whose name this table is aliased with.
otherTable)

Create an alias for this table based on another table's name.

public @NotNull Table<R>

Returns:

The table alias.
as(Table<?>
The other table whose name this table is aliased with.
otherTable, Field<?>...
The other fields whose field name this table's fields are aliased with.
otherFields)

Deprecated as a consequence of Field being deprecated.
Create an alias for this table based on another table's name.
public @NotNull Table<R>

Returns:

The table alias.
as(Table<?>
The other table whose name this table is aliased with.
otherTable, Collection<? extends Field<?>>
The other fields whose field name this table's fields are aliased with.
otherFields)

Create an alias for this table based on another table's name.

public @NotNull Table<R>

Returns:

The table alias
as(Table<?>
The other table whose name is used as alias name
otherTable, Function<? super Field<?>, ? extends Field<?>>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull Table<R>

Returns:

The table alias
as(Table<?>
The other table whose name is used as alias name
otherTable, BiFunction<? super Field<?>, ? super Integer, ? extends Field<?>>
The function providing field aliases.
aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
Create an alias for this table and its fields.
public @NotNull QualifiedAsterisk
asterisk()

Create a qualified asterisk expression from this table (table.*) for use with SELECT.

public @NotNull Table<Record>
crossApply(TableLike<?> table)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossApply(SQL sql)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossApply(String sql)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossApply(String sql, Object... bindings)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossApply(String sql, QueryPart... parts)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossApply(Name name)

CROSS APPLY a table to this table.

public @NotNull Table<Record>
crossJoin(TableLike<?> table)

CROSS JOIN a table to this table.

public @NotNull Table<Record>
crossJoin(SQL sql)

CROSS JOIN a table to this table.

public @NotNull Table<Record>
crossJoin(String sql)

CROSS JOIN a table to this table.

public @NotNull Table<Record>
crossJoin(String sql, Object... bindings)

CROSS JOIN a table to this table.

public @NotNull Table<Record>
crossJoin(String sql, QueryPart... parts)

CROSS JOIN a table to this table.

public @NotNull Table<Record>
crossJoin(Name name)

CROSS JOIN a table to this table.

public @NotNull DivideByOnStep
divideBy(Table<?> divisor)

Create a new TABLE reference from this table, applying relational division.

public @NotNull Condition
eq(Table<R> arg2)

Deprecated as a consequence of Condition being deprecated.
The EQ operator.
public @NotNull Condition
equal(Table<R> arg2)

Deprecated as a consequence of Condition being deprecated.
The EQUAL operator, an alias for the EQ operator.
public boolean
equals(Object
The other QueryPart
other)

Redeclares org.jooq.QueryPart.equals.

Check whether this QueryPart can be considered equal to another QueryPart.
public @NotNull Table<R>
forceIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
forceIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
forceIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
forceIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public R
from(Record record)

The inverse operation of Record#into(Table).

public @NotNull TablePartitionByStep<Record>
fullJoin(TableLike<?> table)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullJoin(SQL sql)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullJoin(String sql)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullJoin(String sql, Object... bindings)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullJoin(String sql, QueryPart... parts)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullJoin(Name name)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(TableLike<?> table)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(SQL sql)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(String sql)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(String sql, Object... bindings)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(String sql, QueryPart... parts)

FULL OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
fullOuterJoin(Name name)

FULL OUTER JOIN a table to this table.

public @NotNull List<Check<R>>
getChecks()

Get a list of CHECK constraints of this table.

public @Nullable Identity<R, ?>

Returns:

The table's IDENTITY information, or null, if no such information is available.
getIdentity()

Retrieve the table's IDENTITY information, if available.

public @NotNull List<Index>

Returns:

All indexes. This is never null.
getIndexes()

Retrieve all of the table's indexes.

public @NotNull List<UniqueKey<R>>

Returns:

All keys. This is never null. This is never empty for a Table with a Table#getPrimaryKey().
getKeys()

Retrieve all of the table's primary and unique keys.

public @NotNull TableOptions
getOptions()

Get the table options.

public @Nullable UniqueKey<R>

Returns:

The primary key. This is never null for an updatable table.
getPrimaryKey()

Retrieve the table's primary key

public @Nullable TableField<R, ?>

Returns:

The "timestamp" field, or null, if this table has no "timestamp" field.
getRecordTimestamp()

Deprecated as a consequence of TableField being deprecated.
A "timestamp" field holding record timestamp information used for optimistic locking

jOOQ supports optimistic locking in UpdatableRecord#store() and UpdatableRecord#delete() if Settings#isExecuteWithOptimisticLocking() is enabled.

public @Nullable TableField<R, ?>

Returns:

The "version" field, or null, if this table has no "version" field.
getRecordVersion()

Deprecated as a consequence of TableField being deprecated.
A "version" field holding record version information used for optimistic locking

jOOQ supports optimistic locking in UpdatableRecord#store() and UpdatableRecord#delete() if Settings#isExecuteWithOptimisticLocking() is enabled.

public @NotNull List<ForeignKey<R, ?>>

Returns:

This table's FOREIGN KEY's. This is never null.
getReferences()

Get the list of FOREIGN KEY's of this table

public <
The other table's record type
O extends Record> @NotNull List<ForeignKey<O, R>>

Returns:

Some other table's FOREIGN KEY's towards an this table. This is never null.
getReferencesFrom(Table<O>
The other table of the foreign key relationship
other)

Get a list of FOREIGN KEY's of a specific table, referencing a this table.

public <
The other table's record type
O extends Record> @NotNull List<ForeignKey<R, O>>

Returns:

This table's FOREIGN KEY's towards an other table. This is never null.
getReferencesTo(Table<O>
The other table of the foreign key relationship
other)

Get a list of FOREIGN KEY's of this table, referencing a specific table.

public @NotNull TableOptions.TableType
getTableType()

Get the table type.

public @NotNull List<UniqueKey<R>>

Returns:

All keys. This is never null.
getUniqueKeys()

Retrieve all of the table's unique keys.

public @NotNull Table<R>
ignoreIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
ignoreIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
ignoreIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
ignoreIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull TableOnStep<Record>
innerJoin(TableLike<?> table)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
innerJoin(SQL sql)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
innerJoin(String sql)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
innerJoin(String sql, Object... bindings)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
innerJoin(String sql, QueryPart... parts)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
innerJoin(Name name)

INNER JOIN a table to this table.

public @NotNull TableOptionalOnStep<Record>
join(TableLike<?> table, JoinType type)

Join a table to this table using a JoinType

Depending on the JoinType, a subsequent TableOnStep#on(Condition) or TableOnStep#using(Field...) clause is required.

public @NotNull TableOnStep<Record>
join(TableLike<?> table)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
join(SQL sql)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
join(String sql)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
join(String sql, Object... bindings)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
join(String sql, QueryPart... parts)

INNER JOIN a table to this table.

public @NotNull TableOnStep<Record>
join(Name name)

INNER JOIN a table to this table.

public @NotNull TableOnStep<R>
leftAntiJoin(TableLike<?> table)

A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT EXISTS predicate.

public @NotNull TablePartitionByStep<Record>
leftJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftJoin(SQL sql)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftJoin(String sql)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftJoin(String sql, Object... bindings)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftJoin(String sql, QueryPart... parts)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftJoin(Name name)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(SQL sql)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(String sql)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(String sql, Object... bindings)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(String sql, QueryPart... parts)

LEFT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
leftOuterJoin(Name name)

LEFT OUTER JOIN a table to this table.

public @NotNull TableOnStep<R>
leftSemiJoin(TableLike<?> table)

A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS predicate.

public @NotNull Table<Record>
naturalFullOuterJoin(TableLike<?> table)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalFullOuterJoin(SQL sql)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalFullOuterJoin(String sql)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalFullOuterJoin(String sql, Object... bindings)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalFullOuterJoin(String sql, QueryPart... parts)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalFullOuterJoin(Name name)

NATURAL FULL OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(TableLike<?> table)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(SQL sql)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(String sql)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(String sql, Object... bindings)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(Name name)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalJoin(String sql, QueryPart... parts)

NATURAL JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(TableLike<?> table)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(SQL sql)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(String sql)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(String sql, Object... bindings)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(String sql, QueryPart... parts)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalLeftOuterJoin(Name name)

NATURAL LEFT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(TableLike<?> table)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(SQL sql)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(String sql)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(String sql, Object... bindings)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(String sql, QueryPart... parts)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Table<Record>
naturalRightOuterJoin(Name name)

NATURAL RIGHT OUTER JOIN a table to this table.

public @NotNull Condition
ne(Table<R> arg2)

Deprecated as a consequence of Condition being deprecated.
The NE operator.
public @NotNull Condition
notEqual(Table<R> arg2)

Deprecated as a consequence of Condition being deprecated.
The NOT_EQUAL operator, an alias for the NE operator.
public @NotNull Table<Record>
outerApply(TableLike<?> table)

OUTER APPLY a table to this table.

public @NotNull Table<Record>
outerApply(SQL sql)

OUTER APPLY a table to this table.

public @NotNull Table<Record>
outerApply(String sql)

OUTER APPLY a table to this table.

public @NotNull Table<Record>
outerApply(String sql, Object... bindings)

OUTER APPLY a table to this table.

public @NotNull Table<Record>
outerApply(String sql, QueryPart... parts)

OUTER APPLY a table to this table.

public @NotNull Table<Record>
outerApply(Name name)

OUTER APPLY a table to this table.

public @NotNull RecordType<R>
recordType()

The record type produced by this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(TableLike<?> table)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(SQL sql)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(String sql)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(String sql, Object... bindings)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(String sql, QueryPart... parts)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightJoin(Name name)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(TableLike<?> table)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(SQL sql)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(String sql)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(String sql, Object... bindings)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(String sql, QueryPart... parts)

RIGHT OUTER JOIN a table to this table.

public @NotNull TablePartitionByStep<Record>
rightOuterJoin(Name name)

RIGHT OUTER JOIN a table to this table.

public @NotNull Field<RowId>
rowid()

Deprecated as a consequence of Field being deprecated.
The ROWID operator.
public @NotNull TableOnStep<Record>
straightJoin(TableLike<?> table)

STRAIGHT_JOIN a table to this table.

public @NotNull TableOnStep<Record>
straightJoin(SQL sql)

STRAIGHT_JOIN a table to this table.

public @NotNull TableOnStep<Record>
straightJoin(String sql)

STRAIGHT_JOIN a table to this table.

public @NotNull TableOnStep<Record>
straightJoin(String sql, Object... bindings)

STRAIGHT_JOIN a table to this table.

public @NotNull TableOnStep<Record>
straightJoin(String sql, QueryPart... parts)

STRAIGHT_JOIN a table to this table.

public @NotNull TableOnStep<Record>
straightJoin(Name name)

STRAIGHT_JOIN a table to this table.

public @NotNull Table<R>
useIndex(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
useIndexForGroupBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
useIndexForJoin(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
useIndexForOrderBy(String... indexes)

Specify a MySQL style table hint for query optimisation.

public @NotNull Table<R>
where(Condition condition)

Deprecated as a consequence of Condition being deprecated.
Add a WHERE clause to the table, connecting them with each other with Operator#AND.
public @NotNull Table<R>
where(Condition... conditions)

Deprecated as a consequence of Condition being deprecated.
Add a WHERE clause to the table, connecting them with each other with Operator#AND.
public @NotNull Table<R>
where(Collection<? extends Condition> conditions)

Add a WHERE clause to the table, connecting them with each other with Operator#AND.

public @NotNull Table<R>
where(Field<Boolean> field)

Deprecated as a consequence of Field being deprecated.
Add a WHERE clause to the table.
public @NotNull Table<R>
where(SQL sql)

Add a WHERE clause to the table.

public @NotNull Table<R>
where(String sql)

Add a WHERE clause to the table.

public @NotNull Table<R>
where(String sql, Object... bindings)

Add a WHERE clause to the table.

public @NotNull Table<R>
where(String sql, QueryPart... parts)

Add a WHERE clause to the table.

public @NotNull Table<R>
whereExists(Select<?> select)

Add a WHERE EXISTS clause to the table.

public @NotNull Table<R>
whereNotExists(Select<?> select)

Add a WHERE NOT EXISTS clause to the table.

public @NotNull Table<Record>
withOrdinality()

Add the WITH ORDINALITY clause.

Inherited from org.jooq.RecordQualifier:
getDataTypegetPackagegetRecordTypenewRecord
Inherited from org.jooq.SelectField:
asconvertconvertconvertconvertFromconvertFromconvertToconvertTo
Inherited from org.jooq.TableLike:
asMultisetasMultisetasMultisetasMultisetasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTable