Interface AnalyticQuerySteps.SetWindowEndOptionOne

Enclosing interface:
AnalyticQuerySteps

public static interface AnalyticQuerySteps.SetWindowEndOptionOne
Set the window frame boundary end.
  • Method Details

    • andPreceding

      Set the bound to a number of rows preceding the current row.
      Parameters:
      nRows - number of rows before the current row to include in the window.
      Returns:
      the add aggregate functions step in the fluent analytic query builder.
    • andCurrentRow

      Set the bound to the current row.
      Returns:
      the add aggregate functions step in the fluent analytic query builder.
    • andFollowing

      Set the bound to a number of rows following the current row.
      Parameters:
      nRows - number of rows after the current row to include in the window.
      Returns:
      the add aggregate functions step in the fluent analytic query builder.
    • andUnBoundedFollowing

      Set the bound to the last partition row.
      Returns:
      the add aggregate functions step in the fluent analytic query builder.