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 Summary

Modifier and Type	Method and Description
AnalyticQuerySteps.SetWindowStart	rowsBetween() The first step in defining a window frame.

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.