Skip to main content

STDDEV_SAMP

Description

Returns the sample standard deviation of the expr expression

Syntax

STDDEV_SAMP(<expr>)

Parameters

ParameterDescription
<expr>The value to be calculated standard deviation, supports type Double.

Return Value

Return the sample standard deviation of the expr expression as Double type. If there is no valid data in the group, returns NULL.

Examples

-- Create sample tables
CREATE TABLE score_table (
student_id INT,
score DOUBLE
) DISTRIBUTED BY HASH(student_id)
PROPERTIES (
"replication_num" = "1"
);

-- Insert test data
INSERT INTO score_table VALUES
(1, 85),
(2, 90),
(3, 82),
(4, 88),
(5, 95);

-- Calculate the sample standard deviation of all students' scores
SELECT STDDEV_SAMP(score) as score_stddev
FROM score_table;
+-------------------+
| score_stddev |
+-------------------+
| 4.949747468305831 |
+-------------------+