Numbers & math Scalar

power()

Computes x to the power of y

Alias of **

Arguments & returns

Scalar

Overload link	`x`	`y`	Returns
#01	`DOUBLE`	`DOUBLE`	`DOUBLE`

SELECT power(2, 3);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  pow(2, 3);

POW(2S, 3)

In DuckDB

POWER(TRY_CAST(2 AS SMALLINT), 3)

POW(2S, 3)

In DuckDB

POWER(TRY_CAST(2 AS SMALLINT), 3)

SQUARE(x)

In DuckDB

POWER(x, 2)