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	OptionallyOrderedAggregateFunction<T>	An ordered-set aggregate function.
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

Subinterfaces of WindowOverStep in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.AnyValue<T>	The ANY VALUE function.
static interface	QOM.ArrayAgg<T>
static interface	QOM.Avg	The AVG function.
static interface	QOM.BitAndAgg<T extends Number>	The BIT AND AGG function.
static interface	QOM.BitNandAgg<T extends Number>	The BIT NAND AGG function.
static interface	QOM.BitNorAgg<T extends Number>	The BIT NOR AGG function.
static interface	QOM.BitOrAgg<T extends Number>	The BIT OR AGG function.
static interface	QOM.BitXNorAgg<T extends Number>	The BIT X NOR AGG function.
static interface	QOM.BitXorAgg<T extends Number>	The BIT XOR AGG function.
static interface	QOM.BoolAnd	The BOOL AND function.
static interface	QOM.BoolOr	The BOOL OR function.
static interface	QOM.Collect<T,A extends ArrayRecord<T>>
static interface	QOM.Corr	The CORR function.
static interface	QOM.Count	The COUNT function.
static interface	QOM.CountTable
static interface	QOM.CovarPop	The COVAR POP function.
static interface	QOM.CovarSamp	The COVAR SAMP function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONObjectAgg<J>
static interface	QOM.Max<T>	The MAX function.
static interface	QOM.MaxBy<T>	The MAX BY function.
static interface	QOM.Median	The MEDIAN function.
static interface	QOM.Min<T>	The MIN function.
static interface	QOM.MinBy<T>	The MIN BY function.
static interface	QOM.Mode<T>
static interface	QOM.MultisetAgg<R extends Record>
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.RatioToReport
static interface	QOM.RegrAvgX	The REGR AVGX function.
static interface	QOM.RegrAvgY	The REGR AVGY function.
static interface	QOM.RegrCount	The REGR COUNT function.
static interface	QOM.RegrIntercept	The REGR INTERCEPT function.
static interface	QOM.RegrR2	The REGR R2 function.
static interface	QOM.RegrSlope	The REGR SLOPE function.
static interface	QOM.RegrSxx	The REGR SXX function.
static interface	QOM.RegrSxy	The REGR SXY function.
static interface	QOM.RegrSyy	The REGR SYY function.
static interface	QOM.StddevPop	The STDDEV POP function.
static interface	QOM.StddevSamp	The STDDEV SAMP function.
static interface	QOM.Sum	The SUM function.
static interface	QOM.VarPop	The VAR POP function.
static interface	QOM.VarSamp	The VAR SAMP function.
static interface	QOM.XMLAgg

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 percent_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.