|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
T
- The function return typepublic interface WindowRowsAndStep<T>
This type is used for the window function DSL API.
Example:
field.firstValue()
.ignoreNulls()
.over()
.partitionBy(AUTHOR_ID)
.orderBy(PUBLISHED_IN.asc())
.rowsBetweenUnboundedPreceding()
.andUnboundedFollowing()
Note, that the functionality provided by this interface is not supported in
SQLDialect.SQLSERVER
Method Summary | |
---|---|
WindowFinalStep<T> |
andCurrentRow()
Add a ... |
WindowFinalStep<T> |
andFollowing(int number)
Add a ... |
WindowFinalStep<T> |
andPreceding(int number)
Add a ... |
WindowFinalStep<T> |
andUnboundedFollowing()
Add a ... |
WindowFinalStep<T> |
andUnboundedPreceding()
Add a ... |
Method Detail |
---|
WindowFinalStep<T> andUnboundedPreceding()
... AND UNBOUNDED PRECEDING
frame clause to the window
function.
WindowFinalStep<T> andPreceding(int number)
... AND [number] PRECEDING
frame clause to the window
function.
WindowFinalStep<T> andCurrentRow()
... AND CURRENT ROW
frame clause to the window
function.
WindowFinalStep<T> andUnboundedFollowing()
... AND UNBOUNDED FOLLOWING
frame clause to the window
function.
WindowFinalStep<T> andFollowing(int number)
... AND [number] FOLLOWING
frame clause to the window
function.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |