Math

POWER

DuckDB

Menghitung base pangkat exponent. POW adalah alias, dan ** adalah operator alternatif.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

POWER(base, exponent) | POW(base, exponent) | base ** exponent

basenumericwajib

Angka dasar

exponentnumericwajib

Pangkat

SQL

1 SELECT POWER(2, 10);

2 pangkat 10.

Hasil

1024

SQL

1 SELECT
2   POWER(16, 0.5) as sqrt_16,
3   POWER(27, 1.0/3) as cbrt_27;

Akar kuadrat dan akar pangkat tiga menggunakan POWER.

Hasil

sqrt_16	cbrt_27
4	3

SQL

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

Menghitung nilai investasi dengan bunga majemuk.

Hasil

principal	rate	years	future_value
1000000	10	5	1610510.0

SQL

1 SELECT 2 ** 8 as power_result;

Alternatif menggunakan operator **.

Hasil

256

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