Top Description Methods
org.jooq

public Interface UpdateOrderByStep<R extends org.jooq.Record>

extends UpdateLimitStep<R extends Record>
Known Direct Subinterfaces
org.jooq.UpdateWhereStep, org.jooq.UpdateConditionStep
Imports
org.jetbrains.annotations.*, java.util.Collection

Deprecated

as a consequence of UpdateLimitStep being deprecated. See corresponding docs for further information.

This type is used for the Update's DSL API.

Example:


DSLContext create = DSL.using(configuration);

create.update(table)
      .set(field1, value1)
      .set(field2, value2)
      .where(field1.greaterThan(100))
      .execute();

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull UpdateLimitStep<R>
orderBy(OrderField<?>... fields)

Deprecated as a consequence of UpdateLimitStep being deprecated.
Add an ORDER BY clause to the query.
public @NotNull UpdateLimitStep<R>
orderBy(Collection<? extends OrderField<?>> fields)

Deprecated as a consequence of UpdateLimitStep being deprecated.
Add an ORDER BY clause to the query.
public @NotNull UpdateLimitStep<R>
orderBy(int... fieldIndexes)

Deprecated as a consequence of UpdateLimitStep being deprecated.
Add an ORDER BY clause to the query.
Inherited from org.jooq.UpdateLimitStep:
limitlimit

Method Detail

orderByback to summary
public @NotNull UpdateLimitStep<R> orderBy(OrderField<?>... fields)

Deprecated

as a consequence of UpdateLimitStep being deprecated. See corresponding docs for further information.

Add an ORDER BY clause to the query.

Annotations
@NotNull
@CheckReturnValue
@Support
orderByback to summary
public @NotNull UpdateLimitStep<R> orderBy(Collection<? extends OrderField<?>> fields)

Deprecated

as a consequence of UpdateLimitStep being deprecated. See corresponding docs for further information.

Add an ORDER BY clause to the query.

Annotations
@NotNull
@CheckReturnValue
@Support
orderByback to summary
public @NotNull UpdateLimitStep<R> orderBy(int... fieldIndexes)

Deprecated

as a consequence of UpdateLimitStep being deprecated. See corresponding docs for further information.

Add an ORDER BY clause to the query.

Indexes start at 1 in SQL!

Note, you can use orderBy(DSL.val(1).desc()) or orderBy(DSL.literal(1).desc()) to apply descending ordering

Annotations
@NotNull
@CheckReturnValue
@Support