org.jooq

Interface WindowSpecificationRowsStep

All Superinterfaces:

QueryPart, Serializable, WindowSpecification, WindowSpecificationFinalStep

All Known Subinterfaces:

WindowSpecificationOrderByStep, WindowSpecificationPartitionByStep

public interface WindowSpecificationRowsStep
extends WindowSpecificationFinalStep

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
WindowSpecificationRowsAndStep	rowsBetweenCurrentRow() Add a ROWS BETWEEN CURRENT ROW ...
WindowSpecificationRowsAndStep	rowsBetweenFollowing(int number) Add a ROWS BETWEEN [number] FOLLOWING ...
WindowSpecificationRowsAndStep	rowsBetweenPreceding(int number) Add a ROWS BETWEEN [number] PRECEDING ...
WindowSpecificationRowsAndStep	rowsBetweenUnboundedFollowing() Add a ROWS BETWEEN UNBOUNDED FOLLOWING ...
WindowSpecificationRowsAndStep	rowsBetweenUnboundedPreceding() Add a ROWS BETWEEN UNBOUNDED PRECEDING ...
WindowSpecificationFinalStep	rowsCurrentRow() Add a ROWS CURRENT ROW frame clause to the window specification.
WindowSpecificationFinalStep	rowsFollowing(int number) Add a ROWS [number] FOLLOWING frame clause to the window specification.
WindowSpecificationFinalStep	rowsPreceding(int number) Add a ROWS [number] PRECEDING frame clause to the window specification.
WindowSpecificationFinalStep	rowsUnboundedFollowing() Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.
WindowSpecificationFinalStep	rowsUnboundedPreceding() Add a ROWS UNBOUNDED PRECEDING frame clause to the window specification.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

rowsUnboundedPreceding

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep rowsUnboundedPreceding()

Add a ROWS UNBOUNDED PRECEDING frame clause to the window specification.

rowsPreceding

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep rowsPreceding(int number)

Add a ROWS [number] PRECEDING frame clause to the window specification.

rowsCurrentRow

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep rowsCurrentRow()

Add a ROWS CURRENT ROW frame clause to the window specification.

rowsUnboundedFollowing

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep rowsUnboundedFollowing()

Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.

rowsFollowing

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep rowsFollowing(int number)

Add a ROWS [number] FOLLOWING frame clause to the window specification.

rowsBetweenUnboundedPreceding

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()

Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.

rowsBetweenPreceding

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenPreceding(int number)

Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window specification.

rowsBetweenCurrentRow

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenCurrentRow()

Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window specification.

rowsBetweenUnboundedFollowing

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()

Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.

rowsBetweenFollowing

@Support(value={DB2,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenFollowing(int number)

Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window specification.