Interface AnalyticQuerySteps.DefineWindowFame

  • Enclosing interface:
    AnalyticQuerySteps

    public static interface AnalyticQuerySteps.DefineWindowFame
    First step in defining a window frame. The window frame clause here matches a window frame clause in SQL.

    SQL Grammar for the window frame clause:

     { ROWS }
     {
       { UNBOUNDED PRECEDING | numeric_expression PRECEDING | CURRENT ROW }
       |
       { BETWEEN window_frame_boundary_start AND window_frame_boundary_end }
     }
    
     window_frame_boundary_start:
     { UNBOUNDED PRECEDING | numeric_expression { PRECEDING | FOLLOWING } | CURRENT ROW }
    
     window_frame_boundary_end:
     { UNBOUNDED FOLLOWING | numeric_expression { PRECEDING | FOLLOWING } | CURRENT ROW }
     
    • Method Detail

      • rowsBetween

        AnalyticQuerySteps.SetWindowStart rowsBetween()
        The first step in defining a window frame.
        Returns:
        the set window start step in the fluent query builder.