"You can make more friends in two months by becoming interested in other people than you will in two years by trying to get other people interested in you."
- Dale Carnegie
Above, is the Stats_Table data in which we will use in our statistical examples.
SELECT VAR(col1) AS Variance_Example,
VARP(col1) AS Var_EntirePopulation
FROM Stats_Table ;
The VAR and VARP functions return the statistical variance of all the values in the specified expression. The VAR uses a sample of the data population ...