Uses of Interface org.jooq.WindowOverStep (jOOQ 3.14.16 API)

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`	`JSONObjectAggNullStep<T>`	A step in the construction of `DSL.jsonObjectAgg(JSONEntry)` or `DSL.jsonbObjectAgg(JSONEntry)` functions where the `NULL` 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<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.