Uses of Interface
org.jooq.WindowOverStep

Packages that use WindowOverStep

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

Uses of WindowOverStep in org.jooq

Subinterfaces of WindowOverStep in org.jooq

Modifier and Type	Interface and 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 is a special field that is usually used in a GROUP BY context.
interface	ArrayAggOrderByStep<T> The SQL standard ARRAY_AGG() function.
interface	GroupConcatOrderByStep MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep MySQL's GROUP_CONCAT function.
interface	WindowBeforeOverStep<T> This type is used for the window function DSL API.
interface	WindowIgnoreNullsStep<T> This type is used for the window function DSL API.

Methods in org.jooq that return WindowOverStep

Modifier and Type	Method and Description
WindowOverStep<T>	WindowIgnoreNullsStep.ignoreNulls() Add an IGNORE NULLS clause to the window function.
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 and Description
static WindowOverStep<BigDecimal>	DSL.cumeDist() The cume_dist() over ([analytic clause]) function.
static WindowOverStep<Integer>	DSL.denseRank() The dense_rank() over ([analytic clause]) function.
static WindowOverStep<Integer>	DSL.ntile(int number) The ntile([number]) over ([analytic clause]) function.
static WindowOverStep<BigDecimal>	DSL.percentRank() The precent_rank() over ([analytic clause]) function.
static WindowOverStep<Integer>	DSL.rank() The rank() over ([analytic clause]) function.
static WindowOverStep<BigDecimal>	DSL.ratioToReport(Field<? extends Number> field) The ratio_to_report([expression]) over ([analytic clause]) function.
static WindowOverStep<BigDecimal>	DSL.ratioToReport(Number number) The ratio_to_report([expression]) over ([analytic clause]) function.
static WindowOverStep<Integer>	DSL.rowNumber() The row_number() over ([analytic clause]) function.