SelectQuery
| Modifier and Type | Class and Description |
|---|---|
| private static enum | SelectImpl.ConditionStep
The
This enumeration models the step that is currently receiving new
conditions via the |
| Modifier and Type | Field and Description |
|---|---|
| private transient SelectImpl. | conditionStep
The step that is currently receiving new conditions |
| private transient ConditionProviderImpl | joinConditions
A temporary member holding a join condition |
| private transient Field | joinPartitionBy
A temporary member holding a join partition by expression |
| private transient TableLike | joinTable
A temporary member holding a join table |
| private transient JoinType | joinType
A temporary member holding a join type |
| private transient Number | limit
The limit that has been added in a limit(Number).offset(Number) construct |
| private transient Field | limitParam
Deprecated
as a consequence of
Field being deprecated.
|
| private transient Number | |
| private transient Field | offsetParam
Deprecated
as a consequence of
Field being deprecated.
|
| Access | Constructor and Description |
|---|---|
| pack-priv | |
| pack-priv | |
| pack-priv | SelectImpl(SelectQueryImpl<R> query)
Deprecated
as a consequence of
SelectQueryImpl being deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
| public final boolean | $distinct()
Implements org. QOM.
|
| public final Select | $distinct(boolean newDistinct)
Implements org. QOM.
|
| public final QOM. | $distinctOn()
Implements org. QOM.
|
| public final Select | $distinctOn(Collection<? extends SelectFieldOrAsterisk> newDistinctOn)
Implements org. QOM.
|
| public final QOM. | $from()
Implements org. QOM.
|
| public final Select | $from(Collection<? extends Table<?>> newFrom)
Implements org. QOM.
|
| public final QOM. | $groupBy()
Implements org. QOM.
|
| public final Select | $groupBy(Collection<? extends GroupField> newGroupBy)
Implements org. QOM.
|
| public final boolean | $groupByDistinct()
Implements org. QOM.
|
| public final Select | $groupByDistinct(boolean newGroupByDistinct)
Implements org. QOM.
|
| public final Condition | $having()
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final Select | $having(Condition newHaving)
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final Field | $limit()
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Field being deprecated.
QOM.
|
| public final Select | |
| public final boolean | $limitPercent()
Implements org. QOM.
|
| public final Select | $limitPercent(boolean newLimitPercent)
Implements org. QOM.
|
| public final boolean | $limitWithTies()
Implements org. QOM.
|
| public final Select | $limitWithTies(boolean newLimitWithTies)
Implements org. QOM.
|
| public final Field | $offset()
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Field being deprecated.
QOM.
|
| public final Select | |
| public QOM. | $orderBy()
Implements org. QOM.
|
| public final Select | $orderBy(Collection<? extends SortField<?>> newOrderBy)
Implements org. QOM.
|
| public final Condition | $qualify()
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final Select | $qualify(Condition newQualify)
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final QOM. | $select()
Implements org. QOM.
|
| public final Select | $select(Collection<? extends SelectFieldOrAsterisk> newSelect)
Implements org. QOM.
|
| public final Condition | $where()
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final Select | $where(Condition newWhere)
Implements org.
Deprecated
as a consequence of
Experimental query object model accessor method, see also Condition being deprecated.
QOM.
|
| public final QOM. | $window()
Implements org. QOM.
|
| public final Select | $window(Collection<? extends WindowDefinition> newWindow)
Implements org. QOM.
|
| public final QOM. | $with()
Implements org. QOM.
|
| public final Select | $with(QOM.
Implements org. QOM.
|
| public final SelectImpl | and(Condition condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with another one using the
Condition being deprecated.
Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | and(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with another one using the
Field being deprecated.
Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | and(SQL sql)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | and(String sql)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | and(String sql, Object... bindings)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | and(String sql, QueryPart... parts)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | andExists(Select<?> select)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | andNot(Condition condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with a negated other one using
the Condition being deprecated.
Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | andNot(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with a negated other one using
the Field being deprecated.
Operator#AND operator and proceed to the next step.
|
| public final SelectImpl | andNotExists(Select<?> select)
Implements org. Operator#AND operator and proceed to the next step.
|
| public final <T> Field | asField()
Implements org.
Deprecated
as a consequence of
The underlying field representation of this object.
Field being deprecated.
|
| public final <T> Field | asField(String alias)
Implements org.
Deprecated
as a consequence of
The underlying field representation of this object.
Field being deprecated.
|
| public final <T> Field | |
| public final Field | asMultiset()
Implements org.
Deprecated
as a consequence of
Turn this Field being deprecated.
TableLike expression into a
DSL#multiset(TableLike).
|
| public final Field | asMultiset(String alias)
Implements org.
Deprecated
as a consequence of
Turn this Field being deprecated.
TableLike expression into a
DSL#multiset(TableLike).
|
| public final Field | asMultiset(Name alias)
Implements org.
Deprecated
as a consequence of
Turn this Field being deprecated.
TableLike expression into a
DSL#multiset(TableLike).
|
| public final Field | asMultiset(Field<?> alias)
Implements org.
Deprecated
as a consequence of
Turn this Field being deprecated.
TableLike expression into a
DSL#multiset(TableLike).
|
| public final Table | |
| public final Table | asTable(String alias)
Implements org. |
| public final Table | asTable(String alias, String... fieldAliases)
Implements org. |
| public final Table | asTable(String alias, Collection<? extends String> fieldAliases)
Implements org. |
| public final Table | asTable(Name alias)
Implements org. |
| public final Table | asTable(Name alias, Name... fieldAliases)
Implements org. |
| public final Table | asTable(Name alias, Collection<? extends Name> fieldAliases)
Implements org. |
| public final Table | asTable(Table<?> alias)
Implements org. |
| public final Table | asTable(Table<?> alias, Field<?>... fieldAliases)
Implements org.
Deprecated
as a consequence of
The underlying aliased table representation of this object.
Field being deprecated.
|
| public final Table | asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)
Implements org. |
| public final Table | |
| public final Table | asTable(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction)
Implements org. |
| public final BetweenAndStep | between(R minValue)
Implements org. |
| public final Condition | between(R minValue, R maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is within a range of two records.
Condition being deprecated.
|
| public final BetweenAndStep | between(Select<? extends R> minValue)
Implements org. |
| public final Condition | between(Select<? extends R> minValue, Select<? extends R> maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is within a range of two subqueries.
Condition being deprecated.
|
| public final BetweenAndStepR | betweenSymmetric(R minValue)
Implements org. |
| public final Condition | betweenSymmetric(R minValue, R maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is within a symmetric range of two records.
Condition being deprecated.
|
| public final BetweenAndStepR | betweenSymmetric(Select<? extends R> minValue)
Implements org. |
| public final Condition | betweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is within a symmetric range of two subqueries.
Condition being deprecated.
|
| public final <X extends Record> CloseableResultQuery | coerce(Table<X> table)
Implements org. |
| public final CloseableResultQuery | coerce(Collection<? extends Field<?>> fields)
Implements org. |
| public final Condition | compare(Comparator comparator, R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record using a dynamic comparator.
Condition being deprecated.
|
| public final Condition | compare(Comparator comparator, Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a subquery using a dynamic comparator.
Condition being deprecated.
|
| public final Condition | compare(Comparator comparator, QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quantified subquery using a dynamic
comparator.
Condition being deprecated.
|
| public final SelectImpl | crossApply(TableLike<?> table)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossApply(SQL sql)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossApply(String sql)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossApply(String sql, Object... bindings)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossApply(String sql, QueryPart... parts)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossApply(Name name)
Implements org. CROSS APPLY a table to this table.
|
| public final SelectImpl | crossJoin(TableLike<?> table)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(TableLike)
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectJoinStep | crossJoin(SQL sql)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectJoinStep | crossJoin(String sql)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectJoinStep | crossJoin(String sql, Object... bindings)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(String, Object.
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectJoinStep | crossJoin(String sql, QueryPart... parts)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(String, QueryPart.
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectImpl | crossJoin(Name name)
Implements org. CROSS JOIN a table to the last table
added to the FROM clause using
Table#crossJoin(Name)
If this syntax is unavailable, it is emulated with a regular
|
| public final SelectIntoStep | distinctOn(SelectFieldOrAsterisk... fields)
Implements org. ON(…) clause to a
SELECT DISTINCT ON (…) statement.
|
| public final SelectIntoStep | distinctOn(Collection<? extends SelectFieldOrAsterisk> fields)
Implements org. ON(…) clause to a
SELECT DISTINCT ON (…) statement.
|
| public final Condition | eq(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for equality.
Condition being deprecated.
|
| public final Condition | eq(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for equality.
Condition being deprecated.
|
| public final Condition | eq(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for equality.
Condition being deprecated.
|
| public final Condition | equal(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for equality.
Condition being deprecated.
|
| public final Condition | equal(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for equality.
Condition being deprecated.
|
| public final Condition | equal(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for equality.
Condition being deprecated.
|
| public final SelectImpl | except(Select<? extends R> select)
Implements org. EXCEPT (or MINUS) set operation.
|
| public final SelectImpl | exceptAll(Select<? extends R> select)
Implements org. EXCEPT ALL set operation.
|
| public final Result | |
| public final Cursor | fetchLazy()
Overrides default org. Implements org. |
| public final Cursor | |
| public final Results | fetchMany()
Overrides default org. Implements org. |
| public final CloseableResultQuery | fetchSize(int rows)
Implements org. Statement.
|
| public final Row | fieldsRow()
Overrides default org. Implements org. Row.
|
| public final SelectImpl | forKeyShare()
Implements org. FOR KEY SHARE clause to the end of the query.
|
| public final SelectImpl | forNoKeyUpdate()
Implements org. FOR NO KEY UPDATE clause to the end of the query.
|
| public final SelectImpl | forShare()
Implements org. FOR SHARE clause to the end of the query.
|
| public final SelectImpl | forUpdate()
Implements org. FOR UPDATE clause to the end of the query.
|
| public final SelectImpl | |
| public final SelectImpl | from(TableLike<?>... tables)
Implements org. FROM clause to the query.
|
| public final SelectImpl | from(Collection<? extends TableLike<?>> tables)
Implements org. FROM clause to the query.
|
| public final SelectImpl | |
| public final SelectImpl | |
| public final SelectImpl | from(String sql, Object... bindings)
Implements org. FROM clause to the query.
|
| public final SelectImpl | from(String sql, QueryPart... parts)
Implements org. FROM clause to the query.
|
| public final SelectJoinStep | |
| public final SelectOnStep | fullJoin(TableLike<?> table)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(TableLike).
|
| public final SelectImpl | fullJoin(SQL sql)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(String).
|
| public final SelectImpl | fullJoin(String sql)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(String).
|
| public final SelectImpl | fullJoin(String sql, Object... bindings)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(String, Object..
|
| public final SelectImpl | fullJoin(String sql, QueryPart... parts)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(String, QueryPart..
|
| public final SelectImpl | fullJoin(Name name)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(Name).
|
| public final SelectImpl | fullOuterJoin(TableLike<?> table)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it |
| public final SelectImpl | fullOuterJoin(SQL sql)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | fullOuterJoin(String sql)
Implements org. FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table#fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | fullOuterJoin(String sql, Object... bindings)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(String, Object.
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | fullOuterJoin(String sql, QueryPart... parts)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(String, QueryPart.
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | fullOuterJoin(Name name)
Implements org. FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table#fullOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
| public final Condition | ge(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | ge(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | ge(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final Field | getFields(ThrowingSupplier<? extends ResultSetMetaData, SQLException> rs)
Overrides default org.
Deprecated
as a consequence of
Get a list of fields provided a result set.
Field being deprecated.
|
| public final Field | getFields()
Implements org.
Deprecated
as a consequence of
Get a list of fields if we don't have a result set.
Field being deprecated.
|
| public final SelectQuery | getQuery()
Implements org.
Deprecated
as a consequence of
Get the underlying SelectQuery being deprecated.
Query that is being constructed.
|
| public final Class | getRecordType()
Implements org. |
| public final Result | getResult()
Implements org. |
| public final List | |
| public final Condition | greaterOrEqual(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | greaterOrEqual(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | greaterOrEqual(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final Condition | greaterThan(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | greaterThan(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | greaterThan(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final SelectImpl | groupBy(GroupField... fields)
Implements org. GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
|
| public final SelectImpl | groupBy(Collection<? extends GroupField> fields)
Implements org. GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
|
| public final SelectImpl | groupByDistinct(GroupField... fields)
Implements org. GROUP BY DISTINCT clause to the query
This is mostly useful when combined with
|
| public final SelectImpl | groupByDistinct(Collection<? extends GroupField> fields)
Implements org. GROUP BY DISTINCT clause to the query
This is mostly useful when combined with
|
| public final Condition | gt(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | gt(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | gt(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final SelectImpl | having(Condition conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
HAVING clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | having(Condition... conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
HAVING clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | having(Collection<? extends Condition> conditions)
Implements org. HAVING clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | having(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Add a Field being deprecated.
HAVING clause to the query.
|
| public final SelectImpl | |
| public final SelectImpl | |
| public final SelectImpl | having(String sql, Object... bindings)
Implements org. HAVING clause to the query.
|
| public final SelectImpl | having(String sql, QueryPart... parts)
Implements org. HAVING clause to the query.
|
| public final SelectImpl | hint(String hint)
Implements org. |
| public final Condition | in(R... records)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a set of records for equality.
Condition being deprecated.
|
| public final Condition | in(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another subquery for equality.
Condition being deprecated.
|
| public final SelectImpl | innerJoin(TableLike<?> table)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(TableLike).
|
| public final SelectImpl | innerJoin(SQL sql)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(String).
|
| public final SelectImpl | innerJoin(String sql)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(String).
|
| public final SelectImpl | innerJoin(String sql, Object... bindings)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(String, Object..
|
| public final SelectImpl | innerJoin(String sql, QueryPart... parts)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(String, QueryPart..
|
| public final SelectImpl | innerJoin(Name name)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(Name).
|
| public final CloseableResultQuery | intern(Field<?>...
The fields whose values should be interned fields)Implements org.
Deprecated
as a consequence of
Specify a set of fields whose values should be interned.
Field being deprecated.
|
| public final CloseableResultQuery | intern(int...
The field indexes whose values should be interned fieldIndexes)Implements org. |
| public final CloseableResultQuery | intern(String...
The field names whose values should be interned fieldNames)Implements org. |
| public final CloseableResultQuery | intern(Name...
The field names whose values should be interned fieldNames)Implements org. |
| public final SelectImpl | intersect(Select<? extends R> select)
Implements org. INTERSECT set operation.
|
| public final SelectImpl | intersectAll(Select<? extends R> select)
Implements org. INTERSECT ALL set operation.
|
| public final SelectImpl | into(Table<?> table)
Implements org. INTO clause to the SELECT
statement to create a new table from a SELECT statement.
|
| public final Condition | isDistinctFrom(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isDistinctFrom(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isDistinctFrom(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isNotDistinctFrom(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isNotDistinctFrom(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isNotDistinctFrom(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for distinctness.
Condition being deprecated.
|
| public final Condition | isNotNull()
Implements org.
Deprecated
as a consequence of
Check if the result of this subquery Condition being deprecated.
IS NOT NULL
|
| public final Condition | isNull()
Implements org.
Deprecated
as a consequence of
Check if the result of this subquery Condition being deprecated.
IS NULL
|
| public final SelectImpl | join(TableLike<?> table)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(TableLike).
|
| public final SelectImpl | join(TableLike<?> table, JoinType type)
Implements org. FROM clause using Table#join(TableLike, JoinType)
Depending on the |
| public final SelectImpl | join(SQL sql)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(String).
|
| public final SelectImpl | join(String sql)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using Table#join(String).
|
| public final SelectImpl | join(String sql, Object... bindings)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(String, Object..
|
| public final SelectImpl | join(String sql, QueryPart... parts)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(String, QueryPart..
|
| public final SelectImpl | join(Name name)
Implements org. INNER JOIN a table to the last table
added to the FROM clause using
Table#join(Name).
|
| public final Condition | le(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | le(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | le(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final SelectImpl | leftAntiJoin(TableLike<?> table)
Implements org. LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate.
|
| public final SelectImpl | leftJoin(TableLike<?> table)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(TableLike).
|
| public final SelectImpl | leftJoin(SQL sql)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String).
|
| public final SelectImpl | leftJoin(String sql)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String).
|
| public final SelectImpl | leftJoin(String sql, Object... bindings)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String, Object..
|
| public final SelectImpl | leftJoin(String sql, QueryPart... parts)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String, QueryPart..
|
| public final SelectImpl | leftJoin(Name name)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(Name).
|
| public final SelectImpl | leftOuterJoin(TableLike<?> table)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(TableLike)
|
| public final SelectImpl | leftOuterJoin(SQL sql)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String)Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | leftOuterJoin(String sql)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String)Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | leftOuterJoin(String sql, Object... bindings)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String, Object.Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | leftOuterJoin(String sql, QueryPart... parts)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(String, QueryPart.Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | leftOuterJoin(Name name)
Implements org. LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table#leftOuterJoin(Name)
|
| public final SelectImpl | leftSemiJoin(TableLike<?> table)
Implements org. LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate.
|
| public final Condition | lessOrEqual(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | lessOrEqual(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | lessOrEqual(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final Condition | lessThan(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | lessThan(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | lessThan(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final SelectImpl | limit(Number l)
Implements org. LIMIT clause to the query.
|
| public final SelectImpl | limit(Field<? extends Number> l)
Implements org.
Deprecated
as a consequence of
Add a Field being deprecated.
LIMIT clause to the query.
|
| public final SelectImpl | limit(Number o, Number l)
Implements org. LIMIT clause to the query
Note that some dialects do not support bind values at all in
|
| public final SelectImpl | |
| public final SelectImpl | |
| public final SelectImpl | |
| private final SelectImpl | |
| public final Condition | lt(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for order.
Condition being deprecated.
|
| public final Condition | lt(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for order.
Condition being deprecated.
|
| public final Condition | lt(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for order.
Condition being deprecated.
|
| public final CloseableResultQuery | maxRows(int rows)
Implements org. Statement.
|
| public final SelectImpl | naturalFullOuterJoin(TableLike<?> table)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalFullOuterJoin(SQL sql)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalFullOuterJoin(String sql)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalFullOuterJoin(String sql, Object... bindings)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(String, Object.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalFullOuterJoin(String sql, QueryPart... parts)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(String, QueryPart.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalFullOuterJoin(Name name)
Implements org. NATURAL FULL OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalFullOuterJoin(Name)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(TableLike<?> table)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(TableLike)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(SQL sql)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(String sql)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(String sql, Object... bindings)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(String, Object.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(String sql, QueryPart... parts)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(String, QueryPart.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalJoin(Name name)
Implements org. NATURAL JOIN a table to the last table
added to the FROM clause using
Table#naturalJoin(Name)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(TableLike<?> table)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(SQL sql)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(String sql)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(String sql, Object... bindings)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(String, Object.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(String sql, QueryPart... parts)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(String, QueryPart.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalLeftOuterJoin(Name name)
Implements org. NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table#naturalLeftOuterJoin(Name)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(TableLike<?> table)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(SQL sql)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(String sql)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(String sql, Object... bindings)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(String, Object.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(String sql, QueryPart... parts)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(String, QueryPart.
Natural joins are supported by most RDBMS. |
| public final SelectImpl | naturalRightOuterJoin(Name name)
Implements org. NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table#naturalRightOuterJoin(Name)
Natural joins are supported by most RDBMS. |
| public final Condition | ne(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for non-equality.
Condition being deprecated.
|
| public final Condition | ne(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for non-equality.
Condition being deprecated.
|
| public final Condition | ne(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for non-equality.
Condition being deprecated.
|
| public final BetweenAndStepR | notBetween(R minValue)
Implements org. |
| public final Condition | notBetween(R minValue, R maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is not within a range of two records.
Condition being deprecated.
|
| public final BetweenAndStepR | notBetween(Select<? extends R> minValue)
Implements org. |
| public final Condition | notBetween(Select<? extends R> minValue, Select<? extends R> maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is not within a range of two subqueries.
Condition being deprecated.
|
| public final BetweenAndStepR | notBetweenSymmetric(R minValue)
Implements org. |
| public final Condition | notBetweenSymmetric(R minValue, R maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is not within a symmetric range of two records.
Condition being deprecated.
|
| public final BetweenAndStepR | notBetweenSymmetric(Select<? extends R> minValue)
Implements org. |
| public final Condition | notBetweenSymmetric(Select<? extends R> minValue, Select<? extends R> maxValue)
Implements org.
Deprecated
as a consequence of
Check if this subquery is not within a symmetric range of two subqueries.
Condition being deprecated.
|
| public final Condition | notEqual(R record)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a record for non-equality.
Condition being deprecated.
|
| public final Condition | notEqual(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another record for non-equality.
Condition being deprecated.
|
| public final Condition | notEqual(QuantifiedSelect<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a quanitified subquery for non-equality.
Condition being deprecated.
|
| public final Condition | notIn(R... records)
Implements org.
Deprecated
as a consequence of
Compare this subquery with a set of records for non-equality.
Condition being deprecated.
|
| public final Condition | notIn(Select<? extends R> select)
Implements org.
Deprecated
as a consequence of
Compare this subquery with another subquery for non-equality.
Condition being deprecated.
|
| public final SelectImpl | noWait()
Implements org. NOWAIT clause to the
FOR <lock_mode> clause at the end of the query.
|
| public final SelectImpl | of(Field<?>... fields)
Implements org.
Deprecated
as a consequence of
Add an Field being deprecated.
OF clause to the FOR <lock_mode> clause at
the end of the query.
|
| public final SelectImpl | of(Collection<? extends Field<?>> fields)
Implements org. OF clause to the FOR <lock_mode> clause at
the end of the query.
|
| public final SelectImpl | of(Table<?>... tables)
Implements org. OF clause to the FOR <lock_mode>
clause at the end of the query.
|
| public final SelectImpl | offset(Number o)
Implements org. OFFSET clause to the query.
|
| public final SelectImpl | offset(Field<? extends Number> o)
Implements org.
Deprecated
as a consequence of
Add a 0-based Field being deprecated.
OFFSET clause to the query.
|
| public final SelectIntoStep | on(SelectFieldOrAsterisk... fields)
Implements org. ON(…) clause to a
SELECT DISTINCT ON (…) statement.
|
| public final SelectIntoStep | on(Collection<? extends SelectFieldOrAsterisk> fields)
Implements org. ON(…) clause to a
SELECT DISTINCT ON (…) statement.
|
| public final SelectImpl | on(Condition conditions)
Implements org.
Deprecated
as a consequence of
Add an Condition being deprecated.
ON clause to the previous JOIN,
connecting them with each other with Operator#AND.
|
| public final SelectImpl | on(Condition... conditions)
Implements org.
Deprecated
as a consequence of
Add an Condition being deprecated.
ON clause to the previous JOIN,
connecting them with each other with Operator#AND.
|
| public final SelectImpl | on(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Add an Field being deprecated.
ON clause to the previous JOIN.
|
| public final SelectImpl | |
| public final SelectImpl | |
| public final SelectImpl | on(String sql, Object... bindings)
Implements org. ON clause to the previous JOIN.
|
| public final SelectImpl | on(String sql, QueryPart... parts)
Implements org. ON clause to the previous JOIN.
|
| public final SelectImpl | onKey()
Implements org. |
| public final SelectImpl | onKey(TableField<?, ?>... keyFields)
Implements org.
Deprecated
as a consequence of
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
TableField being deprecated.
|
| public final SelectImpl | onKey(ForeignKey<?, ?> key)
Implements org. |
| public final SelectImpl | option(String hint)
Implements org. |
| public final SelectImpl | or(Condition condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with another one using the
Condition being deprecated.
Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | or(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with another one using the
Field being deprecated.
Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | or(SQL sql)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | or(String sql)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | or(String sql, Object... bindings)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | or(String sql, QueryPart... parts)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectSeekStep1 | orderBy(OrderField<T> t1)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep2 | orderBy(OrderField<T> t1, OrderField<T> t2)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep3 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep4 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep5 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep6 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep7 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep8 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep9 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep10 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep11 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep12 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep13 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep14 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep15 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep16 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep17 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep18 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17, OrderField<T> t18)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep19 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17, OrderField<T> t18, OrderField<T> t19)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep20 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17, OrderField<T> t18, OrderField<T> t19, OrderField<T> t20)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep21 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17, OrderField<T> t18, OrderField<T> t19, OrderField<T> t20, OrderField<T> t21)
Implements org. ORDER BY clause to the query.
|
| public final SelectSeekStep22 | orderBy(OrderField<T> t1, OrderField<T> t2, OrderField<T> t3, OrderField<T> t4, OrderField<T> t5, OrderField<T> t6, OrderField<T> t7, OrderField<T> t8, OrderField<T> t9, OrderField<T> t10, OrderField<T> t11, OrderField<T> t12, OrderField<T> t13, OrderField<T> t14, OrderField<T> t15, OrderField<T> t16, OrderField<T> t17, OrderField<T> t18, OrderField<T> t19, OrderField<T> t20, OrderField<T> t21, OrderField<T> t22)
Implements org. ORDER BY clause to the query.
|
| public final SelectImpl | orderBy(OrderField<?>... fields)
Implements org. ORDER BY clause to the query
|
| public final SelectImpl | orderBy(Collection<? extends OrderField<?>> fields)
Implements org. ORDER BY clause to the query
|
| public final SelectImpl | orderBy(int... fieldIndexes)
Implements org. ORDER BY clause to the query
Indexes start at |
| public final SelectImpl | orExists(Select<?> select)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | orNot(Condition condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with a negated other one using
the Condition being deprecated.
Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | orNot(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Combine the currently assembled conditions with a negated other one using
the Field being deprecated.
Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | orNotExists(Select<?> select)
Implements org. Operator#OR operator and proceed to the next step.
|
| public final SelectImpl | outerApply(TableLike<?> table)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | outerApply(SQL sql)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | outerApply(String sql)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | outerApply(String sql, Object... bindings)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | outerApply(String sql, QueryPart... parts)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | outerApply(Name name)
Implements org. OUTER APPLY a table to this table.
|
| public final SelectImpl | percent()
Implements org. PERCENT clause to a LIMIT clause.
|
| public final SelectImpl | qualify(Condition conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
QUALIFY clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | qualify(Condition... conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
QUALIFY clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | qualify(Collection<? extends Condition> conditions)
Implements org. QUALIFY clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | qualify(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Add a Field being deprecated.
QUALIFY clause to the query.
|
| public final SelectImpl | |
| public final SelectImpl | qualify(String sql)
Implements org. QUALIFY clause to the query.
|
| public final SelectImpl | qualify(String sql, Object... bindings)
Implements org. QUALIFY clause to the query.
|
| public final SelectImpl | qualify(String sql, QueryPart... parts)
Implements org. QUALIFY clause to the query.
|
| public final CloseableResultQuery | resultSetConcurrency(int resultSetConcurrency)
Implements org. ResultSet concurrency of ResultSet
objects created by jOOQ.
|
| public final CloseableResultQuery | resultSetHoldability(int resultSetHoldability)
Implements org. ResultSet holdability of ResultSet
objects created by jOOQ.
|
| public final CloseableResultQuery | resultSetType(int resultSetType)
Implements org. ResultSet type of ResultSet objects
created by jOOQ.
|
| public final SelectImpl | rightJoin(TableLike<?> table)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(TableLike).
|
| public final SelectImpl | rightJoin(SQL sql)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String).
|
| public final SelectImpl | rightJoin(String sql)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String).
|
| public final SelectImpl | rightJoin(String sql, Object... bindings)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String, Object..
|
| public final SelectImpl | rightJoin(String sql, QueryPart... parts)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String, QueryPart..
|
| public final SelectImpl | rightJoin(Name name)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(Name).
|
| public final SelectImpl | rightOuterJoin(TableLike<?> table)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it |
| public final SelectImpl | rightOuterJoin(SQL sql)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | rightOuterJoin(String sql)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | rightOuterJoin(String sql, Object... bindings)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String, Object.
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | rightOuterJoin(String sql, QueryPart... parts)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(String, QueryPart.
This is only possible where the underlying RDBMS supports it Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. |
| public final SelectImpl | rightOuterJoin(Name name)
Implements org. RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table#rightOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
| public final SelectSeekLimitStep | seek(Object t1)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21, Object t22)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21, Field<T> t22)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Object... values)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seek(Field<?>... fields)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21, Object t22)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21, Field<T> t22)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Object... values)
Implements org. SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekAfter(Field<?>... fields)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK AFTER clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | |
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object t1, Object t2, Object t3, Object t4, Object t5, Object t6, Object t7, Object t8, Object t9, Object t10, Object t11, Object t12, Object t13, Object t14, Object t15, Object t16, Object t17, Object t18, Object t19, Object t20, Object t21, Object t22)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<T> t1, Field<T> t2, Field<T> t3, Field<T> t4, Field<T> t5, Field<T> t6, Field<T> t7, Field<T> t8, Field<T> t9, Field<T> t10, Field<T> t11, Field<T> t12, Field<T> t13, Field<T> t14, Field<T> t15, Field<T> t16, Field<T> t17, Field<T> t18, Field<T> t19, Field<T> t20, Field<T> t21, Field<T> t22)
Implements org.
Deprecated
Add a synthetic SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Object... values)
Implements org. SEEK BEFORE clause to the query.
|
| public final SelectSeekLimitStep | seekBefore(Field<?>... fields)
Implements org.
Deprecated
as a consequence of
Add a synthetic Field being deprecated.
SEEK BEFORE clause to the query.
|
| private final List | |
| public final SelectImpl | select(SelectFieldOrAsterisk... fields)
Implements org. |
| public final SelectImpl | select(Collection<? extends SelectFieldOrAsterisk> fields)
Implements org. |
| public final SelectImpl | skipLocked()
Implements org. WAIT clause to the FOR <lock_mode>
clause at the end of the query.
|
| public final SelectImpl | straightJoin(TableLike<?> table)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final SelectImpl | straightJoin(SQL sql)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final SelectImpl | straightJoin(String sql)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final SelectImpl | straightJoin(String sql, Object... bindings)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final SelectImpl | straightJoin(String sql, QueryPart... parts)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final SelectImpl | straightJoin(Name name)
Implements org. STRAIGHT_JOIN a table to this table.
|
| public final void | subscribe(Flow.
the subscriber subscriberOverrides default org. |
| public final void | subscribe(Subscriber<? super R>
the subscriber)Subscriber that will consume signals from this PublisherOverrides default org. Implements org. Publisher to start streaming data.
|
| public final SelectImpl | union(Select<? extends R> select)
Implements org. UNION set operation.
|
| public final SelectImpl | unionAll(Select<? extends R> select)
Implements org. UNION ALL set operation.
|
| public final SelectImpl | using(Field<?>... fields)
Implements org.
Deprecated
as a consequence of
Join the previous table with the Field being deprecated.
USING(column [, column…])
syntax.
|
| public final SelectImpl | using(Collection<? extends Field<?>> fields)
Implements org. USING(column [, column…])
syntax.
|
| private final Object[] | |
| public final SelectImpl | wait(int seconds)
Implements org. WAIT clause to the FOR <lock_mode>
clause at the end of the query.
|
| public final SelectImpl | where(Condition conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
WHERE clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | where(Condition... conditions)
Implements org.
Deprecated
as a consequence of
Add a Condition being deprecated.
WHERE clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | where(Collection<? extends Condition> conditions)
Implements org. WHERE clause to the query, connecting them with each
other with Operator#AND.
|
| public final SelectImpl | where(Field<Boolean> condition)
Implements org.
Deprecated
as a consequence of
Add a Field being deprecated.
WHERE clause to the query.
|
| public final SelectImpl | |
| public final SelectImpl | |
| public final SelectImpl | where(String sql, Object... bindings)
Implements org. WHERE clause to the query.
|
| public final SelectImpl | where(String sql, QueryPart... parts)
Implements org. WHERE clause to the query.
|
| public final SelectImpl | whereExists(Select<?> select)
Implements org. WHERE EXISTS clause to the query.
|
| public final SelectImpl | whereNotExists(Select<?> select)
Implements org. WHERE NOT EXISTS clause to the query.
|
| public final SelectImpl | window(WindowDefinition... definitions)
Implements org.
Deprecated
as a consequence of
Add a WindowDefinition being deprecated.
WINDOW clause to the statement.
|
| public final SelectImpl | window(Collection<? extends WindowDefinition> definitions)
Implements org. WINDOW clause to the statement.
|
| public final SelectFinalStep | withCheckOption()
Implements org. WITH CHECK OPTION clause to the end of the subquery.
|
| public final SelectFinalStep | withReadOnly()
Implements org. WITH READ ONLY clause to the end of the subquery.
|
| public final SelectImpl | withTies()
Implements org. WITH TIES clause to a LIMIT clause.
|