MySQLAggregate FunctionsVAR_SAMP
VAR_POP

VAR_SAMPAggregate Functions

BIT_AND

Returns the sample variance.

Syntax

VAR_SAMP(expr)

Example

Enter values below to update the example in real time.

department_id
salary
employees
SELECT department_id, ROUND(VAR_SAMP(salary), 2) AS var_samp
FROM employees
GROUP BY department_id;