MySQLAggregate FunctionsSTD
GROUP_CONCAT

STDAggregate Functions

STDDEV_SAMP

Returns the population standard deviation.

Syntax

STD(expr)

Example

Enter values below to update the example in real time.

department_id
salary
salary_stddev
employees
SELECT department_id, ROUND(STD(salary), 2) AS salary_stddev
FROM employees
GROUP BY department_id;