|
|
|
|
|
Linklist | |
AVG - average
COUNT - number of records
MAX - maximum value
MIN - minimum value
RANGE - range of values (MAX - MIN)
SUM - sum up the values
STDDEV - standart deviation
VARIANCE - variance
 |
|
COUNT counts the number of records with no NULL-values in the specifyed field or the whole number of records in the table if '*' is used instead of specifying a column.
Example:
SELECT COUNT(DISTINCT preis)
FROM torder
Counts all unique values of the column preis of the table torder.
|
|
SUM( Fieldname )
SUM sums up all values in the specifyed column.
Example:
SELECT SUM(preis)
FROM torder
Sums up all values of the column preis.
|
|
AVG( Fieldname )
AVG calculates the average of all values in the specifyed column.
Beispiel:
SELECT AVG(preis)
FROM torder
Calculates the average of all values of preis.
|
|
MIN( Fieldname )
MIN returns the minimum value of the column.
Example:
SELECT MIN(preis)
FROM torder
Returns the minimum value of preis.
|
|
MAX( Fieldname )
MAX returns the maximum value of the selected column.
Beispiel:
SELECT MAX(preis)
FROM torder
Returns the maximum value of the column preis.
|
|
RANGE( Fieldname )
Example:
SELECT PANGE(preis)
FROM torder
Calculates the difference between the biggest and the lowest preis.
|
|
Informix |
STDDEV( Fieldname )
STDDEV calculates the standart deviation of the values in the specifyed column. Standart deviation is the square root of variance.
Example:
SELECT STDDEV(preis)
FROM torder
Calculate the standart variation of all values of preis.
|
|
Informix |
VARIANCE( Fieldname )
VARIANCE calculates the variance of the values in the column.
Example:
SELECT VARIANCE(preis)
FROM torder
Calculate the variance of all values in the column preis.