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()
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
@NotNull WindowExcludeStep<T>	andCurrentRow() Add a ...
@NotNull WindowExcludeStep<T>	andFollowing(int number) Add a ...
@NotNull WindowExcludeStep<T>	andPreceding(int number) Add a ...
@NotNull WindowExcludeStep<T>	andUnboundedFollowing() Add a ...
@NotNull WindowExcludeStep<T>	andUnboundedPreceding() Add a ...

Method Detail

andUnboundedPreceding

@NotNull
 @Support(value={H2,MARIADB,MYSQL,POSTGRES,SQLITE})
@NotNull WindowExcludeStep<T> andUnboundedPreceding()

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

andPreceding

@NotNull
 @Support(value={H2,MARIADB,MYSQL,POSTGRES,SQLITE})
@NotNull WindowExcludeStep<T> andPreceding(int number)

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

andCurrentRow

@NotNull
 @Support(value={H2,MARIADB,MYSQL,POSTGRES,SQLITE})
@NotNull WindowExcludeStep<T> andCurrentRow()

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

andUnboundedFollowing

@NotNull
 @Support(value={H2,MARIADB,MYSQL,POSTGRES,SQLITE})
@NotNull WindowExcludeStep<T> andUnboundedFollowing()

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

andFollowing

@NotNull
 @Support(value={H2,MARIADB,MYSQL,POSTGRES,SQLITE})
@NotNull WindowExcludeStep<T> andFollowing(int number)

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