Math

SQRT

BigQuery

Menghitung akar kuadrat dari angka.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

SQRT(expression)

expressionFLOAT64/INT64wajib

Angka non-negatif

SQL

1 SELECT
2   SQRT(4) as sqrt_4,
3   SQRT(2) as sqrt_2,
4   SQRT(100) as sqrt_100;

Menghitung akar kuadrat.

Hasil

sqrt_4	sqrt_2	sqrt_100
2.0	1.4142...	10.0

SQL

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

Menghitung jarak antara dua titik.

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