Interface AnalyticQuerySteps.SetWindowEndOptionOne

  • Enclosing interface:
    AnalyticQuerySteps

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

      • andPreceding

        AnalyticQuerySteps.AddAggregateFunctions andPreceding​(int nRows)
        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.
      • andFollowing

        AnalyticQuerySteps.AddAggregateFunctions andFollowing​(int nRows)
        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

        AnalyticQuerySteps.AddAggregateFunctions andUnBoundedFollowing()
        Set the bound to the last partition row.
        Returns:
        the add aggregate functions step in the fluent analytic query builder.