Last updated 3 months ago
SQL Server
Azure Synapse Analytics
Some parts in the output code are omitted for clarity reasons.
Returns the statistical standard deviation for the population for all values in the specified expression. ().
STDEVP ( [ ALL | DISTINCT ] expression )
STDDEV_POP( [ DISTINCT ] expression_1)
Code:
SELECT STDEVP(VACATIONHOURS) AS STDEVP_VACATIONHOURS FROM HumanResources.Employee;
Result:
STDEVP_VACATIONHOURS| --------------------+ 28.736540767245085|
SELECT STDDEV_POP(VACATIONHOURS) AS STDEVP_VACATIONHOURS FROM HumanResources.Employee;
STDEVP_VACATIONHOURS| --------------------+ 28.736540763|
No issues were found.
No related EWIs.