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.



Copyright © 2012. All Rights Reserved.