Interface WindowFrameBuilder<T>

Type Parameters:
T - The builder return type

public interface WindowFrameBuilder<T>
An interface for building a window frame clause for analytics functions.
Since:
1.4.0
Author:
Christian Beikov
  • Method Details

    • betweenUnboundedPreceding

      WindowFrameBetweenBuilder<T> betweenUnboundedPreceding()
      Uses UNBOUNDED PRECEDING as lower bound for the frame and starts a frame between builder for the upper bound.
      Returns:
      The frame between builder
    • betweenPreceding

      WindowFrameBetweenBuilder<T> betweenPreceding​(String expression)
      Uses expression PRECEDING as lower bound for the frame and starts a frame between builder for the upper bound.
      Parameters:
      expression - The expression for the frame bound
      Returns:
      The frame between builder
    • betweenFollowing

      WindowFrameBetweenBuilder<T> betweenFollowing​(String expression)
      Uses expression FOLLOWING as lower bound for the frame and starts a frame between builder for the upper bound.
      Parameters:
      expression - The expression for the frame bound
      Returns:
      The frame between builder
    • betweenCurrentRow

      WindowFrameBetweenBuilder<T> betweenCurrentRow()
      Uses CURRENT ROW as lower bound for the frame and starts a frame between builder for the upper bound.
      Returns:
      The frame between builder
    • unboundedPreceding

      WindowFrameExclusionBuilder<T> unboundedPreceding()
      Uses UNBOUNDED PRECEDING as lower bound and continues to the frame exclusion builder.
      Returns:
      The frame exclusion builder
    • preceding

      WindowFrameExclusionBuilder<T> preceding​(String expression)
      Uses X PRECEDING as lower bound and continues to the frame exclusion builder.
      Parameters:
      expression - The expression for the frame bound
      Returns:
      The frame exclusion builder
    • currentRow

      Uses CURRENT ROW as lower bound and continues to the frame exclusion builder.
      Returns:
      The frame exclusion builder