java.lang.Object
- java.lang.Enum<ExasolAggregateFunction>
- - com.exasol.sql.expression.function.exasol.ExasolAggregateFunction

All Implemented Interfaces:

FunctionName, Serializable, Comparable<ExasolAggregateFunction>
```
@Deprecated(since="4.5.0",
            forRemoval=true)
public enum ExasolAggregateFunction
extends Enum<ExasolAggregateFunction>
implements FunctionName
```
Deprecated, for removal: This API element is subject to removal in a future version.
Use enum ExasolAnalyticAggregateFunctions.

This class is a list of Aggregate Functions that the Exasol database supports.

Enum Constant Summary

Enum Constants
Enum Constant	Description
`APPROXIMATE_COUNT_DISTINCT`	Deprecated, for removal: This API element is subject to removal in a future version. Faster, but only approximate count of distinct values
`AVG`	Deprecated, for removal: This API element is subject to removal in a future version. Average
`CORR`	Deprecated, for removal: This API element is subject to removal in a future version. Correlation coefficient
`COUNT`	Deprecated, for removal: This API element is subject to removal in a future version. Precise count
`COVAR_POP`	Deprecated, for removal: This API element is subject to removal in a future version. Population covariance
`COVAR_SAMP`	Deprecated, for removal: This API element is subject to removal in a future version. Sample covariance
`FIRST_VALUE`	Deprecated, for removal: This API element is subject to removal in a future version. First value in set
`GROUP_CONCAT`	Deprecated, for removal: This API element is subject to removal in a future version. Group concatenation
`LAST_VALUE`	Deprecated, for removal: This API element is subject to removal in a future version. Last value in set
`MAX`	Deprecated, for removal: This API element is subject to removal in a future version. Maximum value
`MEDIAN`	Deprecated, for removal: This API element is subject to removal in a future version. Median
`MIN`	Deprecated, for removal: This API element is subject to removal in a future version. Minimum Value
`REGR_AVGX`	Deprecated, for removal: This API element is subject to removal in a future version. Average of the independent values (x values)
`REGR_AVGY`	Deprecated, for removal: This API element is subject to removal in a future version. Average of the independent values (y values)
`REGR_COUNT`	Deprecated, for removal: This API element is subject to removal in a future version. Number of non-null number pairs
`REGR_INTERCEPT`	Deprecated, for removal: This API element is subject to removal in a future version. y-Intercept of the regression line
`REGR_R2`	Deprecated, for removal: This API element is subject to removal in a future version. Coefficient of determination (goodness of fit)
`REGR_SLOPE`	Deprecated, for removal: This API element is subject to removal in a future version. Slope of the regression line
`REGR_SXX`	Deprecated, for removal: This API element is subject to removal in a future version. Auxiliary function SXX
`REGR_SXY`	Deprecated, for removal: This API element is subject to removal in a future version. Auxiliary function SXY
`REGR_SYY`	Deprecated, for removal: This API element is subject to removal in a future version. Auxiliary function SYY
`STDDEV`	Deprecated, for removal: This API element is subject to removal in a future version. Standard deviation
`STDDEV_POP`	Deprecated, for removal: This API element is subject to removal in a future version. Standard deviation of expr within a window or group of rows
`STDDEV_SAMP`	Deprecated, for removal: This API element is subject to removal in a future version. Standard deviation of expr within a window or group of rows
`SUM`	Deprecated, for removal: This API element is subject to removal in a future version. Sum
`VAR_POP`	Deprecated, for removal: This API element is subject to removal in a future version. Variance of expr within a window or group of rows
`VAR_SAMP`	Deprecated, for removal: This API element is subject to removal in a future version. Variance of expr within a window or group of rows
`VARIANCE`	Deprecated, for removal: This API element is subject to removal in a future version. Variance

Method Summary

All Methods Static Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`static ExasolAggregateFunction`	`valueOf(String name)`	Deprecated, for removal: This API element is subject to removal in a future version. Returns the enum constant of this type with the specified name.
`static ExasolAggregateFunction[]`	`values()`	Deprecated, for removal: This API element is subject to removal in a future version. Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.exasol.sql.expression.function.FunctionName
name

- Enum Constant Detail
  - APPROXIMATE_COUNT_DISTINCT
```
public static final ExasolAggregateFunction APPROXIMATE_COUNT_DISTINCT
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Faster, but only approximate count of distinct values
  - AVG
```
public static final ExasolAggregateFunction AVG
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Average
  - CORR
```
public static final ExasolAggregateFunction CORR
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Correlation coefficient
  - COUNT
```
public static final ExasolAggregateFunction COUNT
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Precise count
  - COVAR_POP
```
public static final ExasolAggregateFunction COVAR_POP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Population covariance
  - COVAR_SAMP
```
public static final ExasolAggregateFunction COVAR_SAMP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Sample covariance
  - FIRST_VALUE
```
public static final ExasolAggregateFunction FIRST_VALUE
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    First value in set
  - GROUP_CONCAT
```
public static final ExasolAggregateFunction GROUP_CONCAT
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Group concatenation
  - LAST_VALUE
```
public static final ExasolAggregateFunction LAST_VALUE
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Last value in set
  - MAX
```
public static final ExasolAggregateFunction MAX
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Maximum value
  - MEDIAN
```
public static final ExasolAggregateFunction MEDIAN
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Median
  - MIN
```
public static final ExasolAggregateFunction MIN
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Minimum Value
  - REGR_SLOPE
```
public static final ExasolAggregateFunction REGR_SLOPE
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Slope of the regression line
  - REGR_INTERCEPT
```
public static final ExasolAggregateFunction REGR_INTERCEPT
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    y-Intercept of the regression line
  - REGR_COUNT
```
public static final ExasolAggregateFunction REGR_COUNT
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Number of non-null number pairs
  - REGR_R2
```
public static final ExasolAggregateFunction REGR_R2
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Coefficient of determination (goodness of fit)
  - REGR_AVGX
```
public static final ExasolAggregateFunction REGR_AVGX
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Average of the independent values (x values)
  - REGR_AVGY
```
public static final ExasolAggregateFunction REGR_AVGY
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Average of the independent values (y values)
  - REGR_SXX
```
public static final ExasolAggregateFunction REGR_SXX
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Auxiliary function SXX
  - REGR_SXY
```
public static final ExasolAggregateFunction REGR_SXY
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Auxiliary function SXY
  - REGR_SYY
```
public static final ExasolAggregateFunction REGR_SYY
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Auxiliary function SYY
  - STDDEV
```
public static final ExasolAggregateFunction STDDEV
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Standard deviation
  - STDDEV_POP
```
public static final ExasolAggregateFunction STDDEV_POP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Standard deviation of expr within a window or group of rows
  - STDDEV_SAMP
```
public static final ExasolAggregateFunction STDDEV_SAMP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Standard deviation of expr within a window or group of rows
  - SUM
```
public static final ExasolAggregateFunction SUM
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Sum
  - VAR_POP
```
public static final ExasolAggregateFunction VAR_POP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Variance of expr within a window or group of rows
  - VAR_SAMP
```
public static final ExasolAggregateFunction VAR_SAMP
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Variance of expr within a window or group of rows
  - VARIANCE
```
public static final ExasolAggregateFunction VARIANCE
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    Variance
- Method Detail
  - values
```
public static ExasolAggregateFunction[] values()
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
    for (ExasolAggregateFunction c : ExasolAggregateFunction.values()) System.out.println(c);
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static ExasolAggregateFunction valueOf(String name)
```
    Deprecated, for removal: This API element is subject to removal in a future version.
    
    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 name
    
    NullPointerException - if the argument is null

Enum ExasolAggregateFunction

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Methods inherited from interface com.exasol.sql.expression.function.FunctionName

Enum Constant Detail

APPROXIMATE_COUNT_DISTINCT

AVG

CORR

COUNT

COVAR_POP

COVAR_SAMP

FIRST_VALUE

GROUP_CONCAT

LAST_VALUE

MAX

MEDIAN

MIN

REGR_SLOPE

REGR_INTERCEPT

REGR_COUNT

REGR_R2

REGR_AVGX

REGR_AVGY

REGR_SXX

REGR_SXY

REGR_SYY

STDDEV

STDDEV_POP

STDDEV_SAMP

SUM

VAR_POP

VAR_SAMP

VARIANCE

Method Detail

values

valueOf