Math

SQRT

MySQL

Menghitung akar kuadrat dari angka. Hanya untuk angka non-negatif.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

SQRT(x)

xnumericwajib

Angka yang akan dihitung akar kuadratnya (>= 0)

SQL

1 SELECT SQRT(144) AS root;

Akar kuadrat dari 144.

Hasil

root: 12

SQL

1 SELECT a.name, b.name,
2   SQRT(POWER(a.x - b.x, 2) + POWER(a.y - b.y, 2)) AS distance
3 FROM points a
4 CROSS JOIN points b
5 WHERE a.id < b.id;

Menghitung jarak antar titik.

Hasil

(distances between points)

SQL

1 SELECT SQRT(AVG(POWER(value - mean, 2))) AS std_dev
2 FROM (SELECT value, AVG(value) OVER() AS mean FROM data) t;

Menghitung standar deviasi manual.

Hasil

(standard deviation)

1	SELECT a.name, b.name,
2	SQRT(POWER(a.x - b.x, 2) + POWER(a.y - b.y, 2)) AS distance
3	FROM points a
4	CROSS JOIN points b
5	WHERE a.id < b.id;

1	SELECT SQRT(AVG(POWER(value - mean, 2))) AS std_dev
2	FROM (SELECT value, AVG(value) OVER() AS mean FROM data) t;