Aggregate

STD

MySQL

Menghitung standar deviasi populasi dari nilai-nilai numerik. Alias untuk STDDEV_POP. Mengukur seberapa tersebar data dari nilai rata-rata.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

STD(expr)

exprnumericwajib

Ekspresi numerik untuk menghitung standar deviasi

SQL

1 SELECT STD(price) AS price_std FROM products;

Menghitung standar deviasi harga semua produk.

Hasil

price_std: 125.50

SQL

1 SELECT category, STD(rating) AS rating_variation
2 FROM products
3 GROUP BY category;

Mengukur variasi rating per kategori produk.

Hasil

Electronics: 0.8, Clothing: 1.2

SQL

1 SELECT department,
2        AVG(salary) AS avg_salary,
3        STD(salary) AS salary_std
4 FROM employees
5 GROUP BY department;

Melihat rata-rata dan variasi gaji per departemen.

Hasil

Sales: avg=50000, std=8000

1	SELECT category, STD(rating) AS rating_variation
2	FROM products
3	GROUP BY category;