Last updated 2 months ago
SQL Server
Azure Synapse Analytics
Some parts in the output code are omitted for clarity reasons.
Returns the statistical variance of all values in the specified expression. ().
VAR ( [ ALL | DISTINCT ] expression )
VAR_SAMP( [DISTINCT] <expr1> )
Code:
SELECT VAR(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS VAR;
Result:
VAR| ----------------+ 28.7862150320948|
SELECT VAR_SAMP(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS VAR;
VAR| ----------+ 828.646176|
No issues were found.
No related EWIs.