CONNX Data Integration Suite
14.8.0 |
Reference Guide
|
SQL Grammar
|
SQL Statistical Functions
|
Quick Links to SQL Statistical Functions
Quick Links to SQL Statistical Functions
"A" Functions
AVEDEVMEAN(numeric_exp) and AVEDEVMEDIAN(numeric_exp)
"C" Functions
COEFVARPCT(numeric_exp) and COEFVARPCTP(numeric_exp)
"F" Functions
FIRST(value_exp)
"K" Functions
KTHLARGEST(numeric_exp, K_numeric_exp)
KTHSMALLEST(numeric_exp, K_numeric_exp)
KURTOSIS(numeric_exp) and KURTOSISP(numeric_exp)
"L" Functions
LAST(value_exp)
"M" Functions
MEDIAN(numeric_exp)
MIDDLE(value_exp)
MODE(value_exp)
MULTIMODALCOUNT(value_exp)
MULTIMODALOCCUR(value_exp)
"Q" Functions
QUANTILE(numeric_exp, Q_numeric_exp)
QUARTILE1(numeric_exp)
QUARTILE3(numeric_exp)
"R" Functions
RANGE(numeric_exp)
RMSERROR(numeric_exp) and RMSERRORP(numeric_exp)
"S" Functions
SKEWNESS(numeric_exp) and SKEWNESSP(numeric_exp)
SORTFIRST(value_exp)
SORTLAST(value_exp)
SORTMIDDLE(value_exp)
STDDEV(numeric_exp) and STDDEVP(numeric_exp)
"T" Functions
TRIMEAN(numeric_exp)
"V" Functions
VARIANCE(numeric_exp) and VARIANCEP(numeric_exp)