Interface JpaWindow

All Known Implementing Classes:

SqmWindow

@Incubating(since="6.3")
public interface JpaWindow

Common contract for window parts used in window and aggregate functions.

Method Summary

Modifier and Type	Method	Description
JpaWindow	frameExclude(FrameExclusion frameExclusion)	Set a FrameExclusion for this window's frame.
JpaWindow	frameGroups(JpaWindowFrame startFrame, JpaWindowFrame endFrame)	Add a GROUPS frame clause to the window and define start and end JpaWindowFrame specifications.
JpaWindow	frameRange(JpaWindowFrame startFrame, JpaWindowFrame endFrame)	Add a RANGE frame clause to the window and define start and end JpaWindowFrame specifications.
JpaWindow	frameRows(JpaWindowFrame startFrame, JpaWindowFrame endFrame)	Add a ROWS frame clause to the window and define start and end JpaWindowFrame specifications.
JpaWindow	orderBy(Order... expressions)	Add order by expressions to the window.
JpaWindow	partitionBy(Expression<?>... expressions)	Add partition by expressions to the window.

Method Details

partitionBy

@Nonnull
JpaWindow partitionBy(@Nonnull
 Expression<?>... expressions)

Add partition by expressions to the window.

Parameters:

expressions - the partition by expressions

Returns:

the modified window

orderBy

@Nonnull
JpaWindow orderBy(@Nonnull
 Order... expressions)

Add order by expressions to the window.

Parameters:

expressions - the order by expressions

Returns:

the modified window

frameRows

@Nonnull
JpaWindow frameRows(@Nullable
 JpaWindowFrame startFrame,
 @Nullable
 JpaWindowFrame endFrame)

Add a ROWS frame clause to the window and define start and end JpaWindowFrame specifications.

Parameters:

startFrame - the start frame

endFrame - the optional end frame

Returns:

the modified window

frameRange

@Nonnull
JpaWindow frameRange(@Nullable
 JpaWindowFrame startFrame,
 @Nullable
 JpaWindowFrame endFrame)

Add a RANGE frame clause to the window and define start and end JpaWindowFrame specifications.

Parameters:

startFrame - the start frame

endFrame - the optional end frame

Returns:

the modified window

frameGroups

@Nonnull
JpaWindow frameGroups(@Nullable
 JpaWindowFrame startFrame,
 @Nullable
 JpaWindowFrame endFrame)

Add a GROUPS frame clause to the window and define start and end JpaWindowFrame specifications.

Parameters:

startFrame - the start frame

endFrame - the optional end frame

Returns:

the modified window

frameExclude

@Nonnull
JpaWindow frameExclude(@Nonnull
 FrameExclusion frameExclusion)

Set a FrameExclusion for this window's frame.

Parameters:

frameExclusion - the frame exclusion

Returns:

the modified window