Deprecated
as a consequence of WindowSpecificationOrderByStep being deprecated. See corresponding docs for further information.
Window definitions can be
WINDOW clause (see
SelectWindowStep#window(WindowDefinition...) OVER clause (see
AggregateFunction#over(WindowDefinition)
The WINDOW clause is only natively supported by
SQLDialect#AURORA_POSTGRESSQLDialect#H2SQLDialect#MYSQLSQLDialect#POSTGRESSQLDialect#SQLITESQLDialect#SYBASE
If your database supports window functions, but not the WINDOW
clause, jOOQ will inline window definitions into their respective window
functions.
Instances can be created using Name#as(WindowSpecification) and
overloads.
| Modifier and Type | Method and Description |
|---|---|
| public @NotNull Name | |
| public @Nullable WindowSpecification |
| $name | back to summary |
|---|---|
| public @NotNull Name $name() Experimental query object model accessor method, see also
| |
| $windowSpecification | back to summary |
|---|---|
| public @Nullable WindowSpecification $windowSpecification() Experimental query object model accessor method, see also
| |