Math

LN

BigQuery

Menghitung logaritma natural (basis e) dari angka.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

LN(expression)

expressionFLOAT64/INT64wajib

Angka positif

SQL

1 SELECT
2   LN(1) as ln_1,
3   LN(EXP(1)) as ln_e,
4   LN(10) as ln_10;

Logaritma natural berbagai nilai.

Hasil

ln_1	ln_e	ln_10
0.0	1.0	2.302..

SQL

1 SELECT
2   revenue,
3   LN(revenue + 1) as log_revenue
4 FROM `project.dataset.sales`;

Log transform untuk menormalkan distribusi skewed.