Math

EXP

PostgreSQL

Menghitung e pangkat number (e^x). e adalah konstanta Euler (~2.71828). Kebalikan dari LN (natural log).

Tipe hasil: double precision

Syntax

SQL

EXP(number)

numbernumericwajib

Eksponen untuk e

SQL

1 SELECT EXP(1), EXP(0), EXP(2);

e^1 = e, e^0 = 1, e^2 = e*e

Hasil

exp	exp	exp
2.71828182845905	1	7.38905609893065

SQL

1 SELECT 
2   principal * EXP(rate * years) AS continuous_compound
3 FROM (
4   SELECT 1000000 AS principal, 0.05 AS rate, 10 AS years
5 ) t;

Menghitung compound interest kontinu.

Hasil

continuous_compound
1648721.27070013

EXP

MySQL

EXP

Snowflake

EXP

BigQuery

EXP

DuckDB

1	SELECT
2	principal * EXP(rate * years) AS continuous_compound
3	FROM (
4	SELECT 1000000 AS principal, 0.05 AS rate, 10 AS years
5	) t;