StDev, StDevP Functions Example

This example uses the Orders table to estimate the standard deviation of the freight charges for orders shipped to the United Kingdom.

SELECT StDev(Freight) AS [Freight Deviation] 
FROM Orders 
WHERE ShipCountry = 'UK';

SELECT StDevP(Freight) AS [Freight DevP] 
FROM Orders 
WHERE ShipCountry = 'UK';