Class OverClause
- java.lang.Object
-
- com.exasol.sql.expression.function.exasol.OverClause
-
public class OverClause extends Object
This represents anOVER
clause of an analytic function in Exasol. See the documentation for details.
-
-
Constructor Summary
Constructors Constructor Description OverClause()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description OrderByClause
getOrderByClause()
Get the order by clause of thisOverClause
.List<ValueExpression>
getPartitionByColumns()
Get the columns of the partition by clause of thisOverClause
.WindowFrameClause
getWindowFrameClause()
Get the window frame clause of thisOverClause
.String
getWindowName()
Get the window name of thisOverClause
.static OverClause
of(String windowName)
Create a newOverClause
with the given window name.OverClause
orderBy(OrderByClause orderByClause)
Set theOrderByClause
for thisOverClause
.OverClause
partitionBy(ValueExpression... columns)
Set the columns for thePARTITION BY
clause of thisOverClause
.OverClause
windowFrame(UnaryOperator<WindowFrameClause> configurator)
Set and configure theWindowFrameClause
for thisOverClause
.OverClause
windowName(String windowName)
Set the window name for thisOverClause
.
-
-
-
Method Detail
-
of
public static OverClause of(String windowName)
Create a newOverClause
with the given window name.- Parameters:
windowName
- window name of the newOverClause
- Returns:
- a new
OverClause
-
windowName
public OverClause windowName(String windowName)
Set the window name for thisOverClause
.- Parameters:
windowName
- name of the window.- Returns:
- this
OverClause
for fluent programming
-
orderBy
public OverClause orderBy(OrderByClause orderByClause)
Set theOrderByClause
for thisOverClause
.- Parameters:
orderByClause
-OrderByClause
for thisOverClause
- Returns:
- this
OverClause
for fluent programming
-
partitionBy
public OverClause partitionBy(ValueExpression... columns)
Set the columns for thePARTITION BY
clause of thisOverClause
.- Parameters:
columns
- columns for thePARTITION BY
clause.- Returns:
- this
OverClause
for fluent programming
-
windowFrame
public OverClause windowFrame(UnaryOperator<WindowFrameClause> configurator)
Set and configure theWindowFrameClause
for thisOverClause
. You configure the clause in the given lambda.- Parameters:
configurator
- lambda configuring theWindowFrameClause
.- Returns:
- this
OverClause
for fluent programming
-
getWindowName
public String getWindowName()
Get the window name of thisOverClause
.- Returns:
- window name
-
getPartitionByColumns
public List<ValueExpression> getPartitionByColumns()
Get the columns of the partition by clause of thisOverClause
.- Returns:
- partition by columns
-
getOrderByClause
public OrderByClause getOrderByClause()
Get the order by clause of thisOverClause
.- Returns:
- the order by clause
-
getWindowFrameClause
public WindowFrameClause getWindowFrameClause()
Get the window frame clause of thisOverClause
.- Returns:
- the window frame clause
-
-