Math

POWER

MySQL

Menghitung x pangkat y (x^y). POW adalah sinonim.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

POWER(x, y) | POW(x, y)

xnumericwajib

Basis (angka yang dipangkatkan)

ynumericwajib

Eksponen (pangkat)

SQL

1 SELECT POWER(2, 10) AS result;

2 pangkat 10 = 1024.

Hasil

result: 1024

SQL

1 SELECT principal,
2   rate, years,
3   ROUND(principal * POWER(1 + rate/100, years), 2) AS final_amount
4 FROM investments;

Menghitung bunga majemuk.

Hasil

(compound interest calculations)

SQL

1 SELECT POWER(27, 1/3) AS cube_root;

Akar pangkat 3 dari 27.

Hasil

cube_root: 3

1	SELECT principal,
2	rate, years,
3	ROUND(principal * POWER(1 + rate/100, years), 2) AS final_amount
4	FROM investments;