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';