SELECT VARIANCE(mark),VAR_POP(mark), VAR_SAMP(mark) FROM `student`
Output is here
VARIANCE(mark) | VAR_POP(mark) | VAR_SAMP(mark) |
---|---|---|
272.1728395061727 | 272.1728395061727 | 282.6410256410255 |
Restrict decimal places by using FORMAT()
SELECT FORMAT(VARIANCE(mark),2) FROM `student`
Output is here
FORMAT(VARIANCE(mark),2) |
---|
272.17 |