org.jooq

Interface WindowSpecificationOrderByStep

All Superinterfaces:

QueryPart, Serializable, WindowSpecification, WindowSpecificationFinalStep, WindowSpecificationRowsStep

All Known Subinterfaces:

WindowSpecificationPartitionByStep

public interface WindowSpecificationOrderByStep
extends WindowSpecificationRowsStep

An intermediate step in the construction of a WindowSpecification.

Example:

 WindowSpecification spec =
 DSL.partitionBy(BOOK.AUTHOR_ID)
    .orderBy(BOOK.ID)
    .rowsBetweenUnboundedPreceding()
    .andCurrentRow();
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
WindowSpecificationRowsStep	orderBy(Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the window specification.
WindowSpecificationRowsStep	orderBy(Field<?>... fields) Add an ORDER BY clause to the window specification.
WindowSpecificationRowsStep	orderBy(SortField<?>... fields) Add an ORDER BY clause to the window specification.

Methods inherited from interface org.jooq.WindowSpecificationRowsStep

rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowSpecificationRowsStep orderBy(Field<?>... fields)

Add an ORDER BY clause to the window specification.

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowSpecificationRowsStep orderBy(SortField<?>... fields)

Add an ORDER BY clause to the window specification.

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowSpecificationRowsStep orderBy(Collection<? extends SortField<?>> fields)

Add an ORDER BY clause to the window specification.