Math

POWER

BigQuery

Menghitung base pangkat exponent (base^exponent).

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

POWER(base, exponent)

baseFLOAT64/INT64wajib

Angka dasar

exponentFLOAT64/INT64wajib

Pangkat

SQL

1 SELECT
2   POWER(2, 10) as two_power_ten,
3   POWER(10, 3) as ten_cubed,
4   POWER(4, 0.5) as square_root_4;

Berbagai operasi pemangkatan.

Hasil

two_power_ten	ten_cubed	square_root_4
1024	1000	2.0

SQL

1 SELECT
2   principal,
3   rate,
4   years,
5   principal * POWER(1 + rate, years) as future_value
6 FROM `project.dataset.investments`;

Menghitung nilai investasi dengan compound interest.

1	SELECT
2	principal,
3	rate,
4	years,
5	principal * POWER(1 + rate, years) as future_value
6	FROM `project.dataset.investments`;