Math

SQRT

DuckDB

Menghitung akar kuadrat dari sebuah angka. Ekuivalen dengan POWER(number, 0.5).

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

SQRT(number)

numbernumericwajib

Angka yang akan dihitung akar kuadratnya (harus >= 0)

SQL

1 SELECT SQRT(16), SQRT(2);

Menghitung akar kuadrat.

Hasil

4, 1.4142135623730951

SQL

1 SELECT
2   point_a,
3   point_b,
4   SQRT(POWER(x2 - x1, 2) + POWER(y2 - y1, 2)) as distance
5 FROM coordinates;

Menghitung jarak Euclidean antara dua titik.

SQL

1 SELECT SQRT(AVG(POWER(value - avg_val, 2))) as stddev
2 FROM (
3   SELECT value, AVG(value) OVER () as avg_val
4   FROM measurements
5 ) sub;

Menghitung standard deviation secara manual.

SQL

1 SELECT
2   area,
3   SQRT(area / PI()) as radius
4 FROM circles;

Menghitung radius dari luas lingkaran (A = πr²).

1	SELECT
2	point_a,
3	point_b,
4	SQRT(POWER(x2 - x1, 2) + POWER(y2 - y1, 2)) as distance
5	FROM coordinates;

1	SELECT SQRT(AVG(POWER(value - avg_val, 2))) as stddev
2	FROM (
3	SELECT value, AVG(value) OVER () as avg_val
4	FROM measurements
5	) sub;