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 of all values in the specified expression. ().
STDEV ( [ ALL | DISTINCT ] expression )
STDDEV( [ DISTINCT ] <expression_1> )
Code:
SELECT STDEV(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS STDEV;
Result:
STDEV| ----------------+ 28.7862150320948|
SELECT STDDEV(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS STDEV;
STDEV| ------------+ 28.786215034|
No issues were found.
No related EWIs.