Interface JpaWindow

All Known Implementing Classes:
SqmWindow

@Incubating public interface JpaWindow
Common contract for window parts used in window and aggregate functions.
  • Method Details

    • partitionBy

      JpaWindow partitionBy(Expression<?>... expressions)
      Add partition by expressions to the window.
      Parameters:
      expressions - the partition by expressions
      Returns:
      the modified window
    • orderBy

      JpaWindow orderBy(Order... expressions)
      Add order by expressions to the window.
      Parameters:
      expressions - the order by expressions
      Returns:
      the modified window
    • frameRows

      JpaWindow frameRows(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
      Add a ROWS frame clause to the window and define start and end JpaWindowFrame specifications.
      Parameters:
      startFrame - the start frame
      endFrame - the optional end frame
      Returns:
      the modified window
    • frameRange

      JpaWindow frameRange(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
      Add a RANGE frame clause to the window and define start and end JpaWindowFrame specifications.
      Parameters:
      startFrame - the start frame
      endFrame - the optional end frame
      Returns:
      the modified window
    • frameGroups

      JpaWindow frameGroups(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
      Add a GROUPS frame clause to the window and define start and end JpaWindowFrame specifications.
      Parameters:
      startFrame - the start frame
      endFrame - the optional end frame
      Returns:
      the modified window
    • frameExclude

      JpaWindow frameExclude(FrameExclusion frameExclusion)
      Set a FrameExclusion for this window's frame.
      Parameters:
      frameExclusion - the frame exclusion
      Returns:
      the modified window