Outdated Version

You are viewing an older version of this section. View current production version.


Aggregate function. Calculates the population standard deviation value from a set of numbers. STD has synonyms STDDEV and STDDEV_POP which are equivalent.


STD returns NULL if there are not matching rows.

STD ( expression )


  • expression: any expression. This may be a column name, the result of another function, or a math operation.

Return Type

A double.


memsql> select std(table_rows) from information_schema.tables;
| std(table_rows) |
|       2.1500    |
1 row in set (2.87 sec)