Uses of Interface
org.jooq.WindowOverStep

Packages that use WindowOverStep

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of WindowOverStep in org.jooq

Subinterfaces of WindowOverStep in org.jooq

Modifier and Type	Interface	Description
interface	AggregateFilterStep<T>	The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
interface	AggregateFunction<T>	An aggregate function.
interface	ArrayAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.
interface	JSONArrayAggNullStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.
interface	JSONArrayAggOrderByStep<J>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
interface	JSONArrayAggReturningStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
interface	JSONObjectAggNullStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
interface	JSONObjectAggReturningStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
interface	WindowBeforeOverStep<T>	This type is used for the window function DSL API.
interface	WindowFromFirstLastStep<T>	This type is used for the window function DSL API.
interface	WindowIgnoreNullsStep<T>	This type is used for the window function DSL API.
interface	XMLAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.

Methods in org.jooq that return WindowOverStep

Modifier and Type	Method	Description
@NotNull WindowOverStep<T>	WindowIgnoreNullsStep.ignoreNulls()	Add an IGNORE NULLS clause to the window function.
@NotNull WindowOverStep<T>	WindowIgnoreNullsStep.respectNulls()	Add a RESPECT NULLS clause to the window function.

Uses of WindowOverStep in org.jooq.impl

Methods in org.jooq.impl that return WindowOverStep

Modifier and Type	Method	Description
static @NotNull WindowOverStep<BigDecimal>	DSL.cumeDist()	The cume_dist() over ([analytic clause]) function.
static @NotNull WindowOverStep<Integer>	DSL.denseRank()	The dense_rank() over ([analytic clause]) function.
static @NotNull WindowOverStep<Integer>	DSL.ntile(int number)	The ntile([number]) over ([analytic clause]) function.
static @NotNull WindowOverStep<Integer>	DSL.ntile(Field<Integer> number)	The ntile([number]) over ([analytic clause]) function.
static @NotNull WindowOverStep<BigDecimal>	DSL.percentRank()	The precent_rank() over ([analytic clause]) function.
static @NotNull WindowOverStep<Integer>	DSL.rank()	The rank() over ([analytic clause]) function.
static @NotNull WindowOverStep<BigDecimal>	DSL.ratioToReport(Number number)	The ratio_to_report([expression]) over ([analytic clause]) function.
static @NotNull WindowOverStep<BigDecimal>	DSL.ratioToReport(Field<? extends Number> field)	The ratio_to_report([expression]) over ([analytic clause]) function.
static @NotNull WindowOverStep<Integer>	DSL.rowNumber()	The row_number() over ([analytic clause]) function.