org.jooq

Interface WindowOverStep<T>

Type Parameters:

T - The function return type

All Known Subinterfaces:

AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, GroupConcatOrderByStep, GroupConcatSeparatorStep, WindowBeforeOverStep<T>, WindowIgnoreNullsStep<T>

public interface WindowOverStep<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()
 

Unlike in WindowBeforeOverStep, OVER() is a mandatory clause.

Author:

Lukas Eder

Method Summary

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.

Method Detail

over

@Support(value={CUBRID,DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowPartitionByStep<T> over()

Turn this aggregate function into a window function.

An example:

 MAX(id) OVER (PARTITION BY 1)
 

Window functions are supported in CUBRID, DB2, Postgres, Oracle, SQL Server and Sybase.

over

@Support(value={CUBRID,DB2,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowFinalStep<T> over(Name name)

Turn this aggregate function into a window function referencing a window name.

An example:

 MAX(id) OVER my_window
 

Window functions are supported in CUBRID, DB2, Postgres, Oracle, SQL Server and Sybase. If the WINDOW clause is not supported (see SelectWindowStep.window(WindowDefinition...), then referenced windows will be inlined.

over

@Support(value={CUBRID,DB2,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowFinalStep<T> over(String name)

Turn this aggregate function into a window function referencing a window name.

An example:

 MAX(id) OVER my_window
 

Window functions are supported in CUBRID, DB2, Postgres, Oracle, SQL Server and Sybase. If the WINDOW clause is not supported (see SelectWindowStep.window(WindowDefinition...), then referenced windows will be inlined.

over

@Support(value={CUBRID,DB2,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowFinalStep<T> over(WindowSpecification specification)

Turn this aggregate function into a window function.

An example:

 MAX(id) OVER (PARTITION BY 1)
 

Window functions are supported in CUBRID, DB2, Postgres, Oracle, SQL Server and Sybase.

over

@Support(value={CUBRID,DB2,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowFinalStep<T> over(WindowDefinition definition)

Turn this aggregate function into a window function referencing a window definition.

An example:

 MAX(id) OVER my_window
 

Window functions are supported in CUBRID, DB2, Postgres, Oracle, SQL Server and Sybase. If the WINDOW clause is not supported (see SelectWindowStep.window(WindowDefinition...), then referenced windows will be inlined.