Top Description Fields Constructors Methods
org.h2.expression.aggregate

public final Enum AggregateType

extends Enum<AggregateType>
Class Inheritance

The type of an aggregate function.

Field Summary

Modifier and TypeField and Description
public static final AggregateType
ANY

The aggregate type for ANY(expression).

public static final AggregateType
ANY_VALUE

The aggregate type for ANY_VALUE(expression).

public static final AggregateType
ARRAY_AGG

The aggregate type for ARRAY_AGG(expression).

public static final AggregateType
AVG

The aggregate type for AVG(expression).

public static final AggregateType
BIT_AND_AGG

The aggregate type for BIT_AND_AGG(expression).

public static final AggregateType
BIT_NAND_AGG

The aggregate type for BIT_NAND_AGG(expression).

public static final AggregateType
BIT_NOR_AGG

The aggregate type for BIT_NOR_AGG(expression).

public static final AggregateType
BIT_OR_AGG

The aggregate type for BIT_OR_AGG(expression).

public static final AggregateType
BIT_XNOR_AGG

The aggregate type for BIT_XNOR_AGG(expression).

public static final AggregateType
BIT_XOR_AGG

The aggregate type for BIT_XOR_AGG(expression).

public static final AggregateType
CORR

The aggregate type for CORR binary set function.

public static final AggregateType
COUNT

The aggregate type for COUNT(expression).

public static final AggregateType
COUNT_ALL

The aggregate type for COUNT(*).

public static final AggregateType
COVAR_POP

The aggregate type for COVAR_POP binary set function.

public static final AggregateType
COVAR_SAMP

The aggregate type for COVAR_SAMP binary set function.

public static final AggregateType
CUME_DIST

The type for CUME_DIST() hypothetical set function.

public static final AggregateType
DENSE_RANK

The type for DENSE_RANK() hypothetical set function.

public static final AggregateType
ENVELOPE

The aggregate type for ENVELOPE(expression).

public static final AggregateType
EVERY

The aggregate type for EVERY(expression).

public static final AggregateType
HISTOGRAM

The aggregate type for HISTOGRAM(expression).

public static final AggregateType
JSON_ARRAYAGG

The aggregate type for JSON_ARRAYAGG(expression).

public static final AggregateType
JSON_OBJECTAGG

The aggregate type for JSON_OBJECTAGG(expression: expression).

public static final AggregateType
LISTAGG

The aggregate type for LISTAGG(...).

public static final AggregateType
MAX

The aggregate type for MAX(expression).

public static final AggregateType
MEDIAN

The aggregate type for MEDIAN(expression).

public static final AggregateType
MIN

The aggregate type for MIN(expression).

public static final AggregateType
MODE

The aggregate type for MODE(expression).

public static final AggregateType
PERCENT_RANK

The type for PERCENT_RANK() hypothetical set function.

public static final AggregateType
PERCENTILE_CONT

The aggregate type for PERCENTILE_CONT(expression).

public static final AggregateType
PERCENTILE_DISC

The aggregate type for PERCENTILE_DISC(expression).

public static final AggregateType
RANK

The type for RANK() hypothetical set function.

public static final AggregateType
REGR_AVGX

The aggregate type for REGR_AVGX binary set function.

public static final AggregateType
REGR_AVGY

The aggregate type for REGR_AVGY binary set function.

public static final AggregateType
REGR_COUNT

The aggregate type for REGR_COUNT binary set function.

public static final AggregateType
REGR_INTERCEPT

The aggregate type for REGR_INTERCEPT binary set function.

public static final AggregateType
REGR_R2

The aggregate type for REGR_R2 binary set function.

public static final AggregateType
REGR_SLOPE

The aggregate type for REGR_SLOPE binary set function.

public static final AggregateType
REGR_SXX

The aggregate type for REGR_SXX binary set function.

public static final AggregateType
REGR_SXY

The aggregate type for REGR_SXY binary set function.

public static final AggregateType
REGR_SYY

The aggregate type for REGR_SYY binary set function.

public static final AggregateType
STDDEV_POP

The aggregate type for STDDEV_POP(expression).

public static final AggregateType
STDDEV_SAMP

The aggregate type for STDDEV_SAMP(expression).

public static final AggregateType
SUM

The aggregate type for SUM(expression).

public static final AggregateType
VAR_POP

The aggregate type for VAR_POP(expression).

public static final AggregateType
VAR_SAMP

The aggregate type for VAR_SAMP(expression).

Constructor Summary

AccessConstructor and Description
private

Method Summary

Modifier and TypeMethod and Description
public static AggregateType
public static AggregateType[]
Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

ANYback to summary
public static final AggregateType ANY

The aggregate type for ANY(expression).

ANY_VALUEback to summary
public static final AggregateType ANY_VALUE

The aggregate type for ANY_VALUE(expression).

ARRAY_AGGback to summary
public static final AggregateType ARRAY_AGG

The aggregate type for ARRAY_AGG(expression).

AVGback to summary
public static final AggregateType AVG

The aggregate type for AVG(expression).

BIT_AND_AGGback to summary
public static final AggregateType BIT_AND_AGG

The aggregate type for BIT_AND_AGG(expression).

BIT_NAND_AGGback to summary
public static final AggregateType BIT_NAND_AGG

The aggregate type for BIT_NAND_AGG(expression).

BIT_NOR_AGGback to summary
public static final AggregateType BIT_NOR_AGG

The aggregate type for BIT_NOR_AGG(expression).

BIT_OR_AGGback to summary
public static final AggregateType BIT_OR_AGG

The aggregate type for BIT_OR_AGG(expression).

BIT_XNOR_AGGback to summary
public static final AggregateType BIT_XNOR_AGG

The aggregate type for BIT_XNOR_AGG(expression).

BIT_XOR_AGGback to summary
public static final AggregateType BIT_XOR_AGG

The aggregate type for BIT_XOR_AGG(expression).

CORRback to summary
public static final AggregateType CORR

The aggregate type for CORR binary set function.

COUNTback to summary
public static final AggregateType COUNT

The aggregate type for COUNT(expression).

COUNT_ALLback to summary
public static final AggregateType COUNT_ALL

The aggregate type for COUNT(*).

COVAR_POPback to summary
public static final AggregateType COVAR_POP

The aggregate type for COVAR_POP binary set function.

COVAR_SAMPback to summary
public static final AggregateType COVAR_SAMP

The aggregate type for COVAR_SAMP binary set function.

CUME_DISTback to summary
public static final AggregateType CUME_DIST

The type for CUME_DIST() hypothetical set function.

DENSE_RANKback to summary
public static final AggregateType DENSE_RANK

The type for DENSE_RANK() hypothetical set function.

ENVELOPEback to summary
public static final AggregateType ENVELOPE

The aggregate type for ENVELOPE(expression).

EVERYback to summary
public static final AggregateType EVERY

The aggregate type for EVERY(expression).

HISTOGRAMback to summary
public static final AggregateType HISTOGRAM

The aggregate type for HISTOGRAM(expression).

JSON_ARRAYAGGback to summary
public static final AggregateType JSON_ARRAYAGG

The aggregate type for JSON_ARRAYAGG(expression).

JSON_OBJECTAGGback to summary
public static final AggregateType JSON_OBJECTAGG

The aggregate type for JSON_OBJECTAGG(expression: expression).

LISTAGGback to summary
public static final AggregateType LISTAGG

The aggregate type for LISTAGG(...).

MAXback to summary
public static final AggregateType MAX

The aggregate type for MAX(expression).

MEDIANback to summary
public static final AggregateType MEDIAN

The aggregate type for MEDIAN(expression).

MINback to summary
public static final AggregateType MIN

The aggregate type for MIN(expression).

MODEback to summary
public static final AggregateType MODE

The aggregate type for MODE(expression).

PERCENT_RANKback to summary
public static final AggregateType PERCENT_RANK

The type for PERCENT_RANK() hypothetical set function.

PERCENTILE_CONTback to summary
public static final AggregateType PERCENTILE_CONT

The aggregate type for PERCENTILE_CONT(expression).

PERCENTILE_DISCback to summary
public static final AggregateType PERCENTILE_DISC

The aggregate type for PERCENTILE_DISC(expression).

RANKback to summary
public static final AggregateType RANK

The type for RANK() hypothetical set function.

REGR_AVGXback to summary
public static final AggregateType REGR_AVGX

The aggregate type for REGR_AVGX binary set function.

REGR_AVGYback to summary
public static final AggregateType REGR_AVGY

The aggregate type for REGR_AVGY binary set function.

REGR_COUNTback to summary
public static final AggregateType REGR_COUNT

The aggregate type for REGR_COUNT binary set function.

REGR_INTERCEPTback to summary
public static final AggregateType REGR_INTERCEPT

The aggregate type for REGR_INTERCEPT binary set function.

REGR_R2back to summary
public static final AggregateType REGR_R2

The aggregate type for REGR_R2 binary set function.

REGR_SLOPEback to summary
public static final AggregateType REGR_SLOPE

The aggregate type for REGR_SLOPE binary set function.

REGR_SXXback to summary
public static final AggregateType REGR_SXX

The aggregate type for REGR_SXX binary set function.

REGR_SXYback to summary
public static final AggregateType REGR_SXY

The aggregate type for REGR_SXY binary set function.

REGR_SYYback to summary
public static final AggregateType REGR_SYY

The aggregate type for REGR_SYY binary set function.

STDDEV_POPback to summary
public static final AggregateType STDDEV_POP

The aggregate type for STDDEV_POP(expression).

STDDEV_SAMPback to summary
public static final AggregateType STDDEV_SAMP

The aggregate type for STDDEV_SAMP(expression).

SUMback to summary
public static final AggregateType SUM

The aggregate type for SUM(expression).

VAR_POPback to summary
public static final AggregateType VAR_POP

The aggregate type for VAR_POP(expression).

VAR_SAMPback to summary
public static final AggregateType VAR_SAMP

The aggregate type for VAR_SAMP(expression).

Constructor Detail

AggregateTypeback to summary
private AggregateType()

Method Detail

valueOfback to summary
public static AggregateType valueOf(String name)
valuesback to summary
public static AggregateType[] values()