Interface AnalyticQuerySteps.SetWindowStart

  • Enclosing interface:
    AnalyticQuerySteps

    public static interface AnalyticQuerySteps.SetWindowStart
    Set the window frame boundary start.
    • Method Detail

      • unboundedPreceding

        AnalyticQuerySteps.SetWindowEndOptionOne unboundedPreceding()
        Set the bound to the first partition row.
        Returns:
        the set window frame end step in the fluent analytic query builder.
      • preceding

        AnalyticQuerySteps.SetWindowEndOptionOne preceding​(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 set window frame end step in the fluent analytic query builder.
      • following

        AnalyticQuerySteps.SetWindowEndOptionTwo following​(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 set window frame end step in the fluent analytic query builder.