Outdated Version
You are viewing an older version of this section. View current production version.
STDDEV_SAMP
Aggregate function. Calculates the sample standard deviation value from a set of numbers. STDDEV_SAMP returns NULL if there are not matching rows.
Syntax
STDDEV_SAMP ( expression )
Arguments
- expression: any expression. This may be a column name, the result of another function, or a math operation.
Return Type
A double.
Examples
select stddev_samp(table_rows) from information_schema.tables;
+-------------------------+
| stddev_samp(table_rows) |
+-------------------------+
| 2.1500 |
+-------------------------+
1 row in set (2.87 sec)
