ASA SQL Reference
SQL Functions
Alphabetical list of functions
Computes the standard deviation of a population consisting of a numeric-expression, as a DOUBLE.
STDDEV_POP ( numeric-expression )
numeric-expression The expression whose population-based standard deviation is calculated over a set of rows. The expression is commonly a column name.
The population-based standard deviation (s) is computed according to the following formula:
s = [ (1/N) * SUM( xi - mean( x ) )2 ]1/2
This standard deviation does not include rows where numeric-expression is NULL. It returns NULL for a group containing no rows.
SQL/92 Vendor extension.
SQL/99 SQL/foundation feature outside of core SQL.
Sybase Not supported by Adaptive Server Enterprise.
The following statement lists the average and variance in the number of items per order in different time periods:
SELECT year( ship_date ) AS Year, quarter( ship_date ) AS Quarter, avg( quantity ) AS Average, STDDEV_POP( quantity ) AS Variance FROM sales_order_items GROUP BY Year, Quarter ORDER BY Year, Quarter
Year | Quarter | Average | Variance |
---|---|---|---|
2000 | 1 | 25.775148 | 14.2794... |
2000 | 2 | 27.050847 | 15.0270... |
... | ... | ... | ... |