Math

POWER

Snowflake

Menghitung pangkat (base^exponent).

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

POWER(base, exponent)

basenumericwajib

Bilangan dasar

exponentnumericwajib

Pangkat

SQL

1 SELECT POWER(5, 2) as result;

5 pangkat 2.

Hasil

SQL

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

Menghitung compound interest.

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