Uses of Interface
org.jooq.GroupField
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of GroupField in org.jooq
Modifier 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
The final step in creating a case statement of the typeinterface
CaseWhenStep<V,T>
The final step in creating a case statement of the typeinterface
Field<T>
A column expression.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 of theJSON ARRAY
function.interface
A step in the construction of theJSON ARRAY
function.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
A step in the construction of theJSON OBJECT
function.interface
A step in the construction of theJSON OBJECT
function.interface
A step in the construction ofDSL.jsonValue(Field, Field)
orDSL.jsonbValue(Field, Field)
functions where theON EMPTY
andON ERROR
clauses can be defined.interface
A step in the construction of theJSON VALUE
function.interface
Param<T>
A named parameter and/or bind value.interface
Parameter<T>
A parameter to a stored procedure or function.interface
interface
TableField<R extends Record,T>
A field contained in a table.interface
A field contained in a UDT.interface
Variable<T>
A local variable reference.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.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.Modifier and TypeMethodDescriptionvoid
SelectQuery.addGroupBy(GroupField... fields)
Adds grouping fields.@NotNull SelectHavingStep<R>
SelectGroupByStep.groupBy(GroupField... fields)
Add aGROUP BY
clause to the queryModifier and TypeMethodDescriptionvoid
SelectQuery.addGroupBy(Collection<? extends GroupField> fields)
Adds grouping fields.@NotNull SelectHavingStep<R>
SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)
Add aGROUP BY
clause to the query -
Uses of GroupField in org.jooq.impl
Modifier and TypeClassDescriptionclass
CustomField<T>
A base class for customField
implementations in client code.Modifier and TypeMethodDescriptionstatic @NotNull GroupField
Create a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull GroupField
DSL.cube(FieldOrRow... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.static @NotNull GroupField
DSL.groupingSets(Collection<? extends Field<?>>... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull GroupField
DSL.groupingSets(Field<?>... fields)
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single field.static @NotNull GroupField
DSL.groupingSets(Field<?>[]... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna, fieldnb)) grouping field.static @NotNull GroupField
Create a ROLLUP(field1, field2, .., fieldn) grouping field.static @NotNull GroupField
DSL.rollup(FieldOrRow... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.