Uses of Interface
org.jooq.GroupField
Packages that use GroupField
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of GroupField in org.jooq
Subinterfaces of GroupField 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
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
CommonTableExpression<R extends Record>
A common table expression.interface
A condition or predicate.interface
ACondition
that always yieldsfalse
.interface
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.jsonExists(Field, Field)
orDSL.jsonbExists(Field, Field)
functions where theON ERROR
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
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 of anJSON_TABLE
expression.interface
A step in the construction of anJSON_TABLE
expression.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
A step in the construction of theLIKE
function.interface
ACondition
that always yieldsnull
.interface
Param<T>
A named parameter and/or bind value.interface
Parameter<T>
A parameter to a stored procedure or function.interface
interface
A table.interface
TableField<R extends Record,
T> A field contained in a table.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
ACondition
that always yieldstrue
.interface
A field contained in a UDT.interface
UDTPathField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interface
UDTPathTableField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.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.interface
A step in the construction of anXMLTABLE
expression.interface
A step in the construction of anXMLTABLE
expression.Methods in org.jooq that return types with arguments of type GroupFieldModifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends GroupField>
Select.$groupBy()
Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends GroupField>
WindowSpecification.$partitionBy()
Experimental query object model accessor method, see alsoQOM
.Methods in org.jooq with parameters of type GroupFieldModifier and TypeMethodDescriptionvoid
SelectQuery.addGroupBy
(GroupField... fields) Adds grouping fields.@NotNull SelectHavingStep<R>
SelectGroupByStep.groupBy
(GroupField... fields) Add aGROUP BY
clause to the query@NotNull SelectHavingStep<R>
SelectGroupByStep.groupByDistinct
(GroupField... fields) Add aGROUP BY DISTINCT
clause to the query@NotNull WindowOrderByStep<T>
WindowPartitionByStep.partitionBy
(GroupField... fields) Add aPARTITION BY
clause to the window functions.@NotNull WindowSpecificationOrderByStep
WindowSpecificationPartitionByStep.partitionBy
(GroupField... fields) Add aPARTITION BY
clause to the window specification.Method parameters in org.jooq with type arguments of type GroupFieldModifier and TypeMethodDescriptionSelect.$groupBy
(Collection<? extends GroupField> newGroupBy) Experimental query object model accessor method, see alsoQOM
.void
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@NotNull SelectHavingStep<R>
SelectGroupByStep.groupByDistinct
(Collection<? extends GroupField> fields) Add aGROUP BY DISTINCT
clause to the query@NotNull WindowOrderByStep<T>
WindowPartitionByStep.partitionBy
(Collection<? extends GroupField> fields) Add aPARTITION BY
clause to the window functions.@NotNull WindowSpecificationOrderByStep
WindowSpecificationPartitionByStep.partitionBy
(Collection<? extends GroupField> fields) Add aPARTITION BY
clause to the window specification. -
Uses of GroupField in org.jooq.impl
Subinterfaces of GroupField in org.jooq.implModifier and TypeInterfaceDescriptionstatic interface
TheABS
function.static interface
TheACOS
function.static interface
TheACOSH
function.static interface
TheACOTH
function.static interface
QOM.Add<T>
TheADD
operator.static interface
TheAND
operator.static interface
QOM.AnyValue<T>
TheANY VALUE
function.static interface
QOM.Array<T>
static interface
QOM.ArrayAgg<T>
static interface
TheARRAY APPEND
function.static interface
TheARRAY CONCAT
function.static interface
QOM.ArrayGet<T>
TheARRAY GET
function.static interface
TheARRAY OVERLAP
function.static interface
TheARRAY PREPEND
function.static interface
static interface
TheARRAY REMOVE
function.static interface
TheARRAY REPLACE
function.static interface
TheASCII
function.static interface
TheASIN
function.static interface
TheASINH
function.static interface
TheATAN
function.static interface
TheATAN2
function.static interface
TheATANH
function.static interface
TheAVG
function.static interface
QOM.Between<T>
TheBETWEEN
predicate.static interface
QOM.BitAnd<T extends Number>
TheBIT AND
operator.static interface
QOM.BitAndAgg<T extends Number>
TheBIT AND AGG
function.static interface
TheBIT COUNT
function.static interface
QOM.BitGet<T extends Number>
TheBIT GET
function.static interface
TheBIT LENGTH
function.static interface
QOM.BitNand<T extends Number>
TheBIT NAND
operator.static interface
QOM.BitNandAgg<T extends Number>
TheBIT NAND AGG
function.static interface
QOM.BitNor<T extends Number>
TheBIT NOR
operator.static interface
QOM.BitNorAgg<T extends Number>
TheBIT NOR AGG
function.static interface
QOM.BitNot<T extends Number>
TheBIT NOT
operator.static interface
TheBIT OR
operator.static interface
QOM.BitOrAgg<T extends Number>
TheBIT OR AGG
function.static interface
QOM.BitSet<T extends Number>
TheBIT SET
function.static interface
QOM.BitXNor<T extends Number>
TheBIT X NOR
operator.static interface
QOM.BitXNorAgg<T extends Number>
TheBIT X NOR AGG
function.static interface
QOM.BitXor<T extends Number>
TheBIT XOR
operator.static interface
QOM.BitXorAgg<T extends Number>
TheBIT XOR AGG
function.static interface
TheBOOL AND
function.static interface
TheBOOL OR
function.static interface
TheCARDINALITY
function.static interface
static interface
QOM.CaseSimple<V,
T> static interface
QOM.Cast<T>
static interface
TheCEIL
function.static interface
TheCHAR LENGTH
function.static interface
QOM.Choose<T>
static interface
TheCHR
function.static interface
QOM.Coalesce<T>
static interface
QOM.Coerce<T>
static interface
static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>
static interface
QOM.CompareCondition<T,
R extends QOM.CompareCondition<T, R>> static interface
static interface
TheFIELD
function.static interface
TheCONNECT BY ISCYCLE
function.static interface
TheCONNECT BY ISLEAF
function.static interface
TheCONNECT BY ROOT
function.static interface
QOM.Contains<T>
TheCONTAINS
operator.static interface
TheCONTAINS IGNORE CASE
operator.static interface
QOM.Convert<T>
static interface
TheCORR
function.static interface
TheCOS
function.static interface
TheCOSH
function.static interface
TheCOT
function.static interface
TheCOTH
function.static interface
TheCOUNT
function.static interface
static interface
TheCOVAR POP
function.static interface
TheCOVAR SAMP
function.static interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
static interface
static interface
TheCURRENT CATALOG
function.static interface
static interface
TheCURRENT SCHEMA
function.static interface
static interface
static interface
TheCURRENT USER
function.static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
QOM.DateAdd<T>
TheDATE ADD
function.static interface
QOM.Decode<V,
T> static interface
QOM.Default<T>
static interface
TheDEGREES
function.static interface
TheDELETING
function.static interface
static interface
QOM.DerivedTable<R extends Record>
static interface
TheDIGITS
function.static interface
QOM.Div<T>
TheDIV
operator.static interface
static interface
static interface
QOM.EndsWith<T>
TheENDS WITH
operator.static interface
TheENDS WITH IGNORE CASE
operator.static interface
QOM.Eq<T>
TheEQ
operator.static interface
TheEQ
operator.static interface
TheE
function.static interface
QOM.Excluded<T>
TheEXCLUDED
function.static interface
TheEXISTS
function.static interface
TheEXP
function.static interface
static interface
ACondition
that is alwaysFALSE
.static interface
static interface
TheCONDITION
function.static interface
static interface
static interface
TheFLOOR
function.static interface
QOM.FullJoin<R extends Record>
static interface
QOM.Function<T>
static interface
QOM.Ge<T>
TheGE
operator.static interface
static interface
TheGE
operator.static interface
QOM.Greatest<T>
static interface
static interface
QOM.Gt<T>
TheGT
operator.static interface
TheGT
operator.static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static interface
QOM.Iif<T>
static interface
QOM.In<T>
TheIN
operator.static interface
QOM.InList<T>
TheIN
predicate accepting a list of values.static interface
TheINSERTING
function.static interface
TheIS DISTINCT FROM
operator.static interface
TheIS DOCUMENT
operator.static interface
TheIS JSON
operator.static interface
TheIS NOT DISTINCT FROM
operator.static interface
TheIS NOT DOCUMENT
operator.static interface
TheIS NOT JSON
operator.static interface
TheIS NOT NULL
operator.static interface
TheIS NULL
operator.static interface
static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
TheJSON ARRAY
function.static interface
static interface
TheJSONB GET ATTRIBUTE
function.static interface
TheJSONB GET ATTRIBUTE AS TEXT
function.static interface
TheJSONB GET ELEMENT
function.static interface
TheJSONB GET ELEMENT AS TEXT
function.static interface
TheJSONB INSERT
function.static interface
TheJSONB KEYS
function.static interface
TheJSONB REMOVE
function.static interface
TheJSONB REPLACE
function.static interface
TheJSONB SET
function.static interface
TheJSON GET ATTRIBUTE
function.static interface
TheJSON GET ATTRIBUTE AS TEXT
function.static interface
TheJSON GET ELEMENT
function.static interface
TheJSON GET ELEMENT AS TEXT
function.static interface
TheJSON INSERT
function.static interface
TheJSON KEYS
function.static interface
TheJSON OBJECT
function.static interface
static interface
TheJSON REMOVE
function.static interface
TheJSON REPLACE
function.static interface
TheJSON SET
function.static interface
QOM.Lag<T>
static interface
static interface
QOM.Lateral<R extends Record>
static interface
QOM.Le<T>
TheLE
operator.static interface
QOM.Lead<T>
static interface
QOM.Least<T>
static interface
TheLEFT
function.static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
TheLE
operator.static interface
TheLEVEL
function.static interface
TheLIKE
operator.static interface
TheLIKE IGNORE CASE
operator.static interface
TheLIKE
operator.static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
TheLN
function.static interface
TheLOG
function.static interface
TheLOG10
function.static interface
TheLOWER
function.static interface
TheLPAD
function.static interface
QOM.Lt<T>
TheLT
operator.static interface
TheLT
operator.static interface
TheLTRIM
function.static interface
QOM.Max<T>
TheMAX
function.static interface
TheMD5
function.static interface
TheMEDIAN
function.static interface
QOM.Min<T>
TheMIN
function.static interface
TheMOD
operator.static interface
QOM.Mode<T>
static interface
QOM.Mul<T>
TheMUL
operator.static interface
QOM.Multiset<R extends Record>
static interface
QOM.MultisetAgg<R extends Record>
static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
QOM.Ne<T>
TheNE
operator.static interface
QOM.Neg<T>
static interface
TheNE
operator.static interface
TheNOT
operator.static interface
TheNOT
operator.static interface
QOM.NotIn<T>
TheNOT IN
operator.static interface
TheNOT IN
predicate accepting a list of values.static interface
TheNOT LIKE
operator.static interface
TheNOT LIKE IGNORE CASE
operator.static interface
TheNOT LIKE
operator.static interface
TheNOT SIMILAR TO
operator.static interface
TheNOT SIMILAR TO
operator.static interface
QOM.NthValue<T>
static interface
static interface
ACondition
that is alwaysNULL
.static interface
QOM.Nullif<T>
TheNULLIF
function.static interface
QOM.Nvl<T>
TheNVL
function.static interface
QOM.Nvl2<T>
static interface
TheOCTET LENGTH
function.static interface
TheOR
operator.static interface
QOM.OuterApply<R extends Record>
static interface
TheOVERLAY
function.static interface
static interface
ThePI
function.static interface
QOM.PlusJoin<T>
ThePLUS
operator.static interface
ThePOSITION
function.static interface
ThePOWER
operator.static interface
QOM.Prior<T>
ThePRIOR
function.static interface
ThePRODUCT
function.static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
TheROWID
operator.static interface
TheRADIANS
function.static interface
TheRAND
function.static interface
static interface
static interface
static interface
TheREGR AVGX
function.static interface
TheREGR AVGY
function.static interface
TheREGR COUNT
function.static interface
TheREGR INTERCEPT
function.static interface
TheREGR R2
function.static interface
TheREGR SLOPE
function.static interface
TheREGR SXX
function.static interface
TheREGR SXY
function.static interface
TheREGR SYY
function.static interface
TheREPEAT
function.static interface
TheREPLACE
function.static interface
TheREVERSE
function.static interface
TheRIGHT
function.static interface
QOM.RightJoin<R extends Record>
static interface
static interface
TheROUND
function.static interface
QOM.RowAsField<R extends Record>
static interface
TheROW EQ
operator.static interface
TheROW GE
operator.static interface
TheROW GT
operator.static interface
static interface
static interface
TheROW LE
operator.static interface
TheROW LT
operator.static interface
TheROW NE
operator.static interface
TheROWNUM
function.static interface
static interface
static interface
static interface
TheRPAD
function.static interface
TheRTRIM
function.static interface
static interface
static interface
static interface
TheSHL
operator.static interface
TheSHR
operator.static interface
TheSIGN
function.static interface
TheSIMILAR TO
operator.static interface
TheSIMILAR TO
operator.static interface
TheSIN
function.static interface
TheSINH
function.static interface
TheSPACE
function.static interface
TheSPLIT PART
function.static interface
TheSQRT
function.static interface
QOM.Square<T extends Number>
TheSQUARE
function.static interface
TheST AREA
function.static interface
TheSTARTS WITH
operator.static interface
TheSTARTS WITH IGNORE CASE
operator.static interface
TheST ASBINARY
function.static interface
TheST ASTEXT
function.static interface
TheST CENTROID
function.static interface
QOM.StContains<T extends Spatial>
TheST CONTAINS
function.static interface
TheST CROSSES
function.static interface
TheSTDDEV POP
function.static interface
TheSTDDEV SAMP
function.static interface
QOM.StDifference<T extends Spatial>
TheST DIFFERENCE
function.static interface
QOM.StDisjoint<T extends Spatial>
TheST DISJOINT
function.static interface
QOM.StDistance<T extends Spatial>
TheST DISTANCE
function.static interface
QOM.StEndPoint<T extends Spatial>
TheST ENDPOINT
function.static interface
QOM.StEquals<T extends Spatial>
TheST EQUALS
function.static interface
TheST EXTERIORRING
function.static interface
QOM.StGeometryN<T extends Spatial>
TheST GEOMETRYN
function.static interface
TheST GEOMETRYTYPE
function.static interface
TheST GEOMFROMTEXT
function.static interface
TheST GEOMFROMWKB
function.static interface
TheST INTERIORRINGN
function.static interface
QOM.StIntersection<T extends Spatial>
TheST INTERSECTION
function.static interface
QOM.StIntersects<T extends Spatial>
TheST INTERSECTS
function.static interface
TheST ISCLOSED
function.static interface
TheST ISEMPTY
function.static interface
TheST LENGTH
function.static interface
TheST NUMGEOMETRIES
function.static interface
TheST NUMINTERIORRING
function.static interface
TheST NUMPOINTS
function.static interface
QOM.StOverlaps<T extends Spatial>
TheST OVERLAPS
function.static interface
QOM.StPointN<T extends Spatial>
TheST POINTN
function.static interface
QOM.StraightJoin<R extends Record>
static interface
TheST SRID
function.static interface
QOM.StStartPoint<T extends Spatial>
TheST STARTPOINT
function.static interface
QOM.StTouches<T extends Spatial>
TheST TOUCHES
function.static interface
QOM.StUnion<T extends Spatial>
TheST UNION
function.static interface
QOM.StWithin<T extends Spatial>
TheST WITHIN
function.static interface
TheST X
function.static interface
TheST Y
function.static interface
TheST Z
function.static interface
QOM.Sub<T>
TheSUB
operator.static interface
TheSUBSTRING
function.static interface
TheSUBSTRING INDEX
function.static interface
TheSUM
function.static interface
TheSYS CONNECT BY PATH
function.static interface
QOM.TableAlias<R extends Record>
static interface
QOM.TableAsField<R extends Record>
static interface
QOM.TableEq<R extends Record>
TheEQ
operator.static interface
QOM.TableNe<R extends Record>
TheNE
operator.static interface
TheTAN
function.static interface
TheTANH
function.static interface
TheTAU
function.static interface
static interface
TheTO CHAR
function.static interface
TheTO DATE
function.static interface
TheTO HEX
function.static interface
TheTO TIMESTAMP
function.static interface
TheTRANSLATE
function.static interface
TheTRIM
function.static interface
ACondition
that is alwaysTRUE
.static interface
TheTRUNC
function.static interface
QOM.TryCast<T>
TheTRY CAST
function.static interface
TheUNIQUE
function.static interface
TheUPDATING
function.static interface
TheUPPER
function.static interface
TheUUID
function.static interface
QOM.Values<R extends Record>
static interface
TheVAR POP
function.static interface
TheVAR SAMP
function.static interface
QOM.WidthBucket<T extends Number>
TheWIDTH BUCKET
function.static interface
static interface
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.static interface
static interface
TheXMLCOMMENT
function.static interface
TheXMLCONCAT
function.static interface
TheXMLDOCUMENT
function.static interface
static interface
static interface
TheXMLFOREST
function.static interface
static interface
TheXMLPI
function.static interface
static interface
TheXMLSERIALIZE
function.static interface
TheXOR
operator.Classes in org.jooq.impl that implement GroupFieldModifier and TypeClassDescriptionclass
A base class for customCondition
implementations in client code.class
CustomField<T>
A base class for customField
implementations in client code.class
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
A common base type for tablesclass
UDTPathFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for UDT path fields.class
UDTPathTableFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for table fields that are alsoUDTPathField
.Methods in org.jooq.impl that return GroupFieldModifier 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.emptyGroupingSet()
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where each grouping set only consists of a single 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.Methods in org.jooq.impl with parameters of type GroupFieldModifier and TypeMethodDescriptionstatic @NotNull WindowSpecificationOrderByStep
DSL.partitionBy
(GroupField... fields) Create aWindowSpecification
with aPARTITION BY
clause.Method parameters in org.jooq.impl with type arguments of type GroupFieldModifier and TypeMethodDescriptionstatic @NotNull WindowSpecificationOrderByStep
DSL.partitionBy
(Collection<? extends GroupField> fields) Create aWindowSpecification
with aPARTITION BY
clause.