WindowRowsAndStep (jOOQ 2.2.0 API)

Overview

Package

Class

Use

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.jooq
Interface WindowRowsAndStep<T>


Type Parameters:: T - The function return type

public interface WindowRowsAndStep<T>

This type is used for the window function DSL API.

Example:

 field.firstValue()
      .ignoreNulls()
      .over()
      .partitionBy(AUTHOR_ID)
      .orderBy(PUBLISHED_IN.asc())
      .rowsBetweenUnboundedPreceding()
      .andUnboundedFollowing()

Note, that the functionality provided by this interface is not supported in SQLDialect.SQLSERVER

Author:: Lukas Eder

Method Summary
`WindowFinalStep<T>`	`andCurrentRow()` Add a `...`
`WindowFinalStep<T>`	`andFollowing(int number)` Add a `...`
`WindowFinalStep<T>`	`andPreceding(int number)` Add a `...`
`WindowFinalStep<T>`	`andUnboundedFollowing()` Add a `...`
`WindowFinalStep<T>`	`andUnboundedPreceding()` Add a `...`

Method Detail

andUnboundedPreceding

WindowFinalStep<T> andUnboundedPreceding()

Add a ... AND UNBOUNDED PRECEDING frame clause to the window function.

andPreceding

WindowFinalStep<T> andPreceding(int number)

Add a ... AND [number] PRECEDING frame clause to the window function.

andCurrentRow

WindowFinalStep<T> andCurrentRow()

Add a ... AND CURRENT ROW frame clause to the window function.

andUnboundedFollowing

WindowFinalStep<T> andUnboundedFollowing()

Add a ... AND UNBOUNDED FOLLOWING frame clause to the window function.

andFollowing

WindowFinalStep<T> andFollowing(int number)

Add a ... AND [number] FOLLOWING frame clause to the window function.