Math

EXP

DuckDB

Menghitung e pangkat number (e^x). e adalah konstanta matematika ≈ 2.718281828.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

EXP(number)

numbernumericwajib

Eksponen untuk basis e

SQL

1 SELECT EXP(1);

e pangkat 1 = e.

Hasil

2.718281828459045

SQL

1 SELECT
2   year,
3   initial_value * EXP(growth_rate * year) as projected_value
4 FROM growth_params;

Model pertumbuhan eksponensial.

SQL

1 SELECT
2   log_value,
3   EXP(log_value) as original_value
4 FROM log_transformed_data;

Mengkonversi nilai log kembali ke nilai asli.

SQL

1 SELECT
2   x,
3   EXP(-POWER(x - mean, 2) / (2 * POWER(stddev, 2))) / (stddev * SQRT(2 * PI())) as pdf
4 FROM data, params;

Menghitung probability density function untuk distribusi normal.

1	SELECT
2	year,
3	initial_value * EXP(growth_rate * year) as projected_value
4	FROM growth_params;

1	SELECT
2	log_value,
3	EXP(log_value) as original_value
4	FROM log_transformed_data;

1	SELECT
2	x,
3	EXP(-POWER(x - mean, 2) / (2 * POWER(stddev, 2))) / (stddev * SQRT(2 * PI())) as pdf
4	FROM data, params;