STDDEVIATION()

Aggregate. Returns the standard deviation of a given expression over multiple rows.

Syntax

STDDEVIATION( [DISTINCT] expression )

The following example returns the standard deviation of the values of the temperature column for the last 24 hours:

INSERT INTO OutStream
SELECT STDDEVIATION(Devices.temperature)
FROM Devices KEEP 24 HOURS;