Var, VarP Functions Example

This example uses the Orders table to estimate the variance of freight costs for orders shipped to the United Kingdom.

SELECT Var(Freight) AS [UK Freight Variance] 
FROM Orders WHERE ShipCountry = 'UK';

SELECT VarP(Freight) AS [UK Freight VarianceP] 
FROM Orders 
WHERE ShipCountry = 'UK';