Package org.h2.expression.aggregate
Enum AggregateType
- All Implemented Interfaces:
Serializable
,Comparable<AggregateType>
,java.lang.constant.Constable
The type of an aggregate function.
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>>
-
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionThe aggregate type for ANY(expression).The aggregate type for ARRAY_AGG(expression).The aggregate type for AVG(expression).The aggregate type for BIT_AND_AGG(expression).The aggregate type for BIT_NAND_AGG(expression).The aggregate type for BIT_NOR_AGG(expression).The aggregate type for BIT_OR_AGG(expression).The aggregate type for BIT_XNOR_AGG(expression).The aggregate type for BIT_XOR_AGG(expression).The aggregate type for CORR binary set function.The aggregate type for COUNT(expression).The aggregate type for COUNT(*).The aggregate type for COVAR_POP binary set function.The aggregate type for COVAR_SAMP binary set function.The type for CUME_DIST() hypothetical set function.The type for DENSE_RANK() hypothetical set function.The aggregate type for ENVELOPE(expression).The aggregate type for EVERY(expression).The aggregate type for HISTOGRAM(expression).The aggregate type for JSON_ARRAYAGG(expression).The aggregate type for JSON_OBJECTAGG(expression: expression).The aggregate type for LISTAGG(...).The aggregate type for MAX(expression).The aggregate type for MEDIAN(expression).The aggregate type for MIN(expression).The aggregate type for MODE(expression).The type for PERCENT_RANK() hypothetical set function.The aggregate type for PERCENTILE_CONT(expression).The aggregate type for PERCENTILE_DISC(expression).The type for RANK() hypothetical set function.The aggregate type for REGR_AVGX binary set function.The aggregate type for REGR_AVGY binary set function.The aggregate type for REGR_COUNT binary set function.The aggregate type for REGR_INTERCEPT binary set function.The aggregate type for REGR_R2 binary set function.The aggregate type for REGR_SLOPE binary set function.The aggregate type for REGR_SXX binary set function.The aggregate type for REGR_SXY binary set function.The aggregate type for REGR_SYY binary set function.The aggregate type for STDDEV_POP(expression).The aggregate type for STDDEV_SAMP(expression).The aggregate type for SUM(expression).The aggregate type for VAR_POP(expression).The aggregate type for VAR_SAMP(expression). -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic AggregateType
Returns the enum constant of this type with the specified name.static AggregateType[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
Enum Constant Details
-
COUNT_ALL
The aggregate type for COUNT(*). -
COUNT
The aggregate type for COUNT(expression). -
SUM
The aggregate type for SUM(expression). -
MIN
The aggregate type for MIN(expression). -
MAX
The aggregate type for MAX(expression). -
AVG
The aggregate type for AVG(expression). -
STDDEV_POP
The aggregate type for STDDEV_POP(expression). -
STDDEV_SAMP
The aggregate type for STDDEV_SAMP(expression). -
VAR_POP
The aggregate type for VAR_POP(expression). -
VAR_SAMP
The aggregate type for VAR_SAMP(expression). -
ANY
The aggregate type for ANY(expression). -
EVERY
The aggregate type for EVERY(expression). -
BIT_AND_AGG
The aggregate type for BIT_AND_AGG(expression). -
BIT_OR_AGG
The aggregate type for BIT_OR_AGG(expression). -
BIT_XOR_AGG
The aggregate type for BIT_XOR_AGG(expression). -
BIT_NAND_AGG
The aggregate type for BIT_NAND_AGG(expression). -
BIT_NOR_AGG
The aggregate type for BIT_NOR_AGG(expression). -
BIT_XNOR_AGG
The aggregate type for BIT_XNOR_AGG(expression). -
HISTOGRAM
The aggregate type for HISTOGRAM(expression). -
COVAR_POP
The aggregate type for COVAR_POP binary set function. -
COVAR_SAMP
The aggregate type for COVAR_SAMP binary set function. -
CORR
The aggregate type for CORR binary set function. -
REGR_SLOPE
The aggregate type for REGR_SLOPE binary set function. -
REGR_INTERCEPT
The aggregate type for REGR_INTERCEPT binary set function. -
REGR_COUNT
The aggregate type for REGR_COUNT binary set function. -
REGR_R2
The aggregate type for REGR_R2 binary set function. -
REGR_AVGX
The aggregate type for REGR_AVGX binary set function. -
REGR_AVGY
The aggregate type for REGR_AVGY binary set function. -
REGR_SXX
The aggregate type for REGR_SXX binary set function. -
REGR_SYY
The aggregate type for REGR_SYY binary set function. -
REGR_SXY
The aggregate type for REGR_SXY binary set function. -
RANK
The type for RANK() hypothetical set function. -
DENSE_RANK
The type for DENSE_RANK() hypothetical set function. -
PERCENT_RANK
The type for PERCENT_RANK() hypothetical set function. -
CUME_DIST
The type for CUME_DIST() hypothetical set function. -
PERCENTILE_CONT
The aggregate type for PERCENTILE_CONT(expression). -
PERCENTILE_DISC
The aggregate type for PERCENTILE_DISC(expression). -
MEDIAN
The aggregate type for MEDIAN(expression). -
LISTAGG
The aggregate type for LISTAGG(...). -
ARRAY_AGG
The aggregate type for ARRAY_AGG(expression). -
MODE
The aggregate type for MODE(expression). -
ENVELOPE
The aggregate type for ENVELOPE(expression). -
JSON_OBJECTAGG
The aggregate type for JSON_OBJECTAGG(expression: expression). -
JSON_ARRAYAGG
The aggregate type for JSON_ARRAYAGG(expression).
-
-
Constructor Details
-
AggregateType
private AggregateType()
-
-
Method Details
-
values
Returns an array containing the constants of this enum type, in the order they are declared.- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is null
-