Class WindowFrameClause
- java.lang.Object
-
- com.exasol.sql.expression.function.exasol.WindowFrameClause
-
public class WindowFrameClause extends Object
This represents a window frame clause of an analytic function in Exasol. See the documentation for details.
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
WindowFrameClause.UnitType
Represents a unit type.static class
WindowFrameClause.WindowFrameExclusionType
Represents the type of a window frame exclusion.static class
WindowFrameClause.WindowFrameType
Window frame clausestatic class
WindowFrameClause.WindowFrameUnitClause
Represents a window frame unit.
-
Method Summary
-
-
-
Method Detail
-
type
public WindowFrameClause type(WindowFrameClause.WindowFrameType type)
Set the type of thisWindowFrameClause
.- Parameters:
type
- type of thisWindowFrameClause
- Returns:
- this
WindowFrameClause
for fluent programming
-
unit
public WindowFrameClause unit(WindowFrameClause.UnitType unitType)
Set the unit type of thisWindowFrameClause
.- Parameters:
unitType
- unit type of thisWindowFrameClause
- Returns:
- this
WindowFrameClause
for fluent programming
-
unit
public WindowFrameClause unit(ValueExpression expression, WindowFrameClause.UnitType unitType)
Set the unit type of thisWindowFrameClause
.- Parameters:
expression
- expression for the unit. Only required for unit typesWindowFrameClause.UnitType.PRECEDING
andWindowFrameClause.UnitType.FOLLOWING
unitType
- unit type of thisWindowFrameClause
- Returns:
- this
WindowFrameClause
for fluent programming
-
unitBetween
public WindowFrameClause unitBetween(WindowFrameClause.UnitType unitType1, WindowFrameClause.UnitType unitType2)
Set the unit type of thisWindowFrameClause
toBETWEEN ... AND ...
.- Parameters:
unitType1
-BETWEEN
unitunitType2
-AND
unit- Returns:
- this
WindowFrameClause
for fluent programming
-
unitBetween
public WindowFrameClause unitBetween(ValueExpression expression1, WindowFrameClause.UnitType unitType1, ValueExpression expression2, WindowFrameClause.UnitType unitType2)
Set the unit type of thisWindowFrameClause
toBETWEEN ... AND ...
.- Parameters:
unitType1
-BETWEEN
unitexpression1
-BETWEEN
expression. Only required for unit typesWindowFrameClause.UnitType.PRECEDING
andWindowFrameClause.UnitType.FOLLOWING
unitType2
-AND
unitexpression2
-AND
expression. Only required for unit typesWindowFrameClause.UnitType.PRECEDING
andWindowFrameClause.UnitType.FOLLOWING
- Returns:
- this
WindowFrameClause
for fluent programming
-
exclude
public WindowFrameClause exclude(WindowFrameClause.WindowFrameExclusionType exclusion)
Set the exclusion type of thisWindowFrameClause
.- Parameters:
exclusion
- exclusion type.- Returns:
- this
WindowFrameClause
for fluent programming
-
getType
public WindowFrameClause.WindowFrameType getType()
Get the window frame type.- Returns:
- window frame type.
-
getUnit1
public WindowFrameClause.WindowFrameUnitClause getUnit1()
Get theBETWEEN
unit.- Returns:
BETWEEN
unit
-
getUnit2
public WindowFrameClause.WindowFrameUnitClause getUnit2()
Get theAND
unit.- Returns:
AND
unit
-
getExclusion
public WindowFrameClause.WindowFrameExclusionType getExclusion()
Get the exclusion type.- Returns:
- exclusion type
-
-