Package tech.tablesaw.analytic

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 Details

    • rowsBetween

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