Uses of Interface
org.jooq.WindowOverStep
Packages that use WindowOverStep
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of WindowOverStep in org.jooq
Subinterfaces of WindowOverStep in org.jooqModifier and TypeInterfaceDescriptioninterface
The step in the specification of aggregate functions where the SQL:2003 standardFILTER clause
can be added.interface
An aggregate function.interface
The SQL standardARRAY_AGG()
function.interface
MySQL'sGROUP_CONCAT
function.interface
MySQL'sGROUP_CONCAT
function.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theORDER BY
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theRETURNING
clause can be defined.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theRETURNING
clause can be defined.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
The SQL standardARRAY_AGG()
function.Methods in org.jooq that return WindowOverStepModifier and TypeMethodDescription@NotNull WindowOverStep<T>
WindowIgnoreNullsStep.ignoreNulls()
Add anIGNORE NULLS
clause to the window function.@NotNull WindowOverStep<T>
WindowIgnoreNullsStep.respectNulls()
Add aRESPECT NULLS
clause to the window function. -
Uses of WindowOverStep in org.jooq.impl
Methods in org.jooq.impl that return WindowOverStepModifier and TypeMethodDescriptionstatic @NotNull WindowOverStep<BigDecimal>
DSL.cumeDist()
Thecume_dist() over ([analytic clause])
function.static @NotNull WindowOverStep<Integer>
DSL.denseRank()
Thedense_rank() over ([analytic clause])
function.static @NotNull WindowOverStep<Integer>
DSL.ntile(int number)
Thentile([number]) over ([analytic clause])
function.static @NotNull WindowOverStep<Integer>
Thentile([number]) over ([analytic clause])
function.static @NotNull WindowOverStep<BigDecimal>
DSL.percentRank()
Theprecent_rank() over ([analytic clause])
function.static @NotNull WindowOverStep<Integer>
DSL.rank()
Therank() over ([analytic clause])
function.static @NotNull WindowOverStep<BigDecimal>
DSL.ratioToReport(Number number)
Theratio_to_report([expression]) over ([analytic clause])
function.static @NotNull WindowOverStep<BigDecimal>
DSL.ratioToReport(Field<? extends Number> field)
Theratio_to_report([expression]) over ([analytic clause])
function.static @NotNull WindowOverStep<Integer>
DSL.rowNumber()
Therow_number() over ([analytic clause])
function.