org.jooq

Interface WindowSpecificationPartitionByStep

All Superinterfaces:

QueryPart, Serializable, WindowSpecification, WindowSpecificationFinalStep, WindowSpecificationOrderByStep, WindowSpecificationRowsStep

public interface WindowSpecificationPartitionByStep
extends WindowSpecificationOrderByStep

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
WindowSpecificationOrderByStep	partitionBy(Collection<? extends Field<?>> fields) Add a PARTITION BY clause to the window specification.
WindowSpecificationOrderByStep	partitionBy(Field<?>... fields) Add a PARTITION BY clause to the window specification.
WindowSpecificationOrderByStep	partitionByOne() Add a PARTITION BY 1 clause to the window specification, where such a clause is required by the syntax of an RDBMS.

Methods inherited from interface org.jooq.WindowSpecificationOrderByStep

orderBy, orderBy, orderBy

Methods inherited from interface org.jooq.WindowSpecificationRowsStep

rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

partitionBy

@Support(value={CUBRID,DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowSpecificationOrderByStep partitionBy(Field<?>... fields)

Add a PARTITION BY clause to the window specification.

partitionBy

@Support(value={CUBRID,DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowSpecificationOrderByStep partitionBy(Collection<? extends Field<?>> fields)

Add a PARTITION BY clause to the window specification.

partitionByOne

@Support(value={CUBRID,DB2,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowSpecificationOrderByStep partitionByOne()

Add a PARTITION BY 1 clause to the window specification, where such a clause is required by the syntax of an RDBMS.

This clause is not supported as such in the CUBRID and Sybase dialects. If you use it, jOOQ will simply ignore it.