Contents Index STDDEV_POP function [Aggregate] STR function [String]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

STDEV_SAMP function [Aggregate]


Function 

Computes the standard deviation of a sample consisting of a numeric-expression, as a DOUBLE.

Syntax 

STDDEV_SAMP ( numeric-expression )

Parameters 

numeric-expression    The expression whose sample-based standard deviation is calculated over a set of rows. The expression is commonly a column name.

Usage 

The standard deviation (s) is computed according to the following formula, which assumes a normal distribution:

s = [ (1/( N - 1 )) * 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.

Standards and compatibility 
See also 

Aggregate functions

Example 

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_SAMP( quantity ) AS Variance
FROM sales_order_items
GROUP BY Year, Quarter
ORDER BY Year, Quarter
Year Quarter Average Variance
2000 1 25.775148 14.3218...
2000 2 27.050847 15.0696...
... ... ... ...

Contents Index STDDEV_POP function [Aggregate] STR function [String]