ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

VAR_POP function [Aggregate]

Function 

Computes the statistical variance of a population consisting of a numeric-expression, as a DOUBLE.

Syntax 

VAR_POP ( numeric-expression )

Parameters 

numeric-expression    The expression whose population-based variance is calculated over a set of rows. The expression is commonly a column name.

Usage 

The population-based variance (s²) is computed according to the following formula:

s² = (1/N) * SUM( x_i - mean( x ) )²

This variance does not include rows where numeric-expression is NULL. It returns NULL for a group containing no rows.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Not supported by Adaptive Server Enterprise.

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,
    var_pop( quantity ) AS Variance
FROM sales_order_items
GROUP BY Year, Quarter
ORDER BY Year, Quarter