Math

LOG10

BigQuery

Menghitung logaritma basis 10 (common logarithm).

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

LOG10(expression)

expressionFLOAT64/INT64wajib

Angka positif

SQL

1 SELECT
2   LOG10(1) as log_1,
3   LOG10(10) as log_10,
4   LOG10(1000) as log_1000;

Logaritma basis 10 untuk powers of 10.

Hasil

log_1	log_10	log_1000
0.0	1.0	3.0

SQL

1 SELECT
2   value,
3   FLOOR(LOG10(value)) as order_of_magnitude
4 FROM UNNEST([5, 50, 500, 5000]) as value;

Menentukan order of magnitude.

1	SELECT
2	value,
3	FLOOR(LOG10(value)) as order_of_magnitude
4	FROM UNNEST([5, 50, 500, 5000]) as value;