Menghitung standar deviasi dari sekumpulan nilai. STDDEV dan STDDEV_SAMP menggunakan sample standard deviation (n-1). STDDEV_POP menggunakan population standard deviation (n).
double precisionDiperbarui: 12 Jul 2026STDDEV(expression)
STDDEV_SAMP(expression)
STDDEV_POP(expression)Kolom numerik yang akan dihitung standar deviasinya
1 SELECT 2 AVG(salary) AS avg_salary, 3 STDDEV(salary) AS stddev_salary 4 FROM employees;
Menghitung rata-rata dan standar deviasi gaji.
| avg_salary | stddev_salary |
|---|---|
| 8500000.00 | 2500000.123 |
1 SELECT 2 STDDEV_SAMP(score) AS sample_stddev, 3 STDDEV_POP(score) AS population_stddev 4 FROM test_scores;
Perbandingan sample dan population standard deviation.
| sample_stddev | population_stddev |
|---|---|
| 15.8113883 | 14.1421356 |
1 SELECT 2 category, 3 AVG(price) AS avg_price, 4 STDDEV(price) AS price_variability 5 FROM products 6 GROUP BY category 7 ORDER BY price_variability DESC;
Menganalisis variabilitas harga per kategori.
Sudah paham STDDEV? Latih langsung di browser
Latihan interaktif, langsung di browser.
COVAR_POP