T
- The function return typepublic interface WindowOverStep<T>
Example:
field.firstValue()
.ignoreNulls()
.over()
.partitionBy(AUTHOR_ID)
.orderBy(PUBLISHED_IN.asc())
.rowsBetweenUnboundedPreceding()
.andUnboundedFollowing()
Unlike in WindowBeforeOverStep
, OVER()
is a mandatory
clause.
Modifier and Type | Method and Description |
---|---|
WindowPartitionByStep<T> |
over()
Turn this aggregate function into a window function.
|
WindowFinalStep<T> |
over(Name name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
over(String name)
Turn this aggregate function into a window function referencing a window
name.
|
WindowFinalStep<T> |
over(WindowDefinition definition)
Turn this aggregate function into a window function referencing a window
definition.
|
WindowFinalStep<T> |
over(WindowSpecification specification)
Turn this aggregate function into a window function.
|
@Support(value={CUBRID,DB2,DERBY,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA}) WindowPartitionByStep<T> over()
An example:
MAX(id) OVER (PARTITION BY 1)
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA}) WindowFinalStep<T> over(Name name)
An example:
MAX(id) OVER my_window
If the WINDOW
clause is not supported (see
SelectWindowStep.window(WindowDefinition...)
, then referenced
windows will be inlined.
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA}) WindowFinalStep<T> over(String name)
An example:
MAX(id) OVER my_window
If the WINDOW
clause is not supported (see
SelectWindowStep.window(WindowDefinition...)
, then referenced
windows will be inlined.
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA}) WindowFinalStep<T> over(WindowSpecification specification)
An example:
MAX(id) OVER (PARTITION BY 1)
@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE,VERTICA}) WindowFinalStep<T> over(WindowDefinition definition)
An example:
MAX(id) OVER my_window
If the WINDOW
clause is not supported (see
SelectWindowStep.window(WindowDefinition...)
, then referenced
windows will be inlined.
Copyright © 2017. All Rights Reserved.