StDev, StDevP Functions Example

This example estimates the standard deviation of the sales amounts for orders shipped to the United Kingdom.

SELECT StDev([Order Amount]) FROM Orders WHERE [Ship Country] = 'UK';

SELECT StDevP([Order Amount]) FROM Orders WHERE [Ship Country] = 'UK';