Math

LOG10

DuckDB

Menghitung logaritma basis 10 dari sebuah angka. Shortcut untuk LOG(10, number).

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

LOG10(number)

Parameter

numberDOUBLEwajib

Angka yang akan dihitung log10-nya (harus > 0)

Contoh Penggunaan

Menghitung Order of Magnitude

SQL

1 SELECT
2   value,
3   LOG10(value) as log10_val,
4   FLOOR(LOG10(value)) as magnitude
5 FROM (
6   SELECT unnest([5, 50, 500, 5000, 50000]) as value
7 );

Menentukan order of magnitude dari angka.

Hasil

value	log10_val	magnitude
5	0.699	0
50	1.699	1
500	2.699	2
5000	3.699	3
... 1 baris lainnya

Grouping by Magnitude

SQL

1 SELECT
2   CASE FLOOR(LOG10(amount))
3     WHEN 3 THEN 'Thousands'
4     WHEN 4 THEN 'Ten Thousands'
5     WHEN 5 THEN 'Hundred Thousands'
6     WHEN 6 THEN 'Millions'
7     ELSE 'Other'
8   END as amount_range,
9   COUNT(*) as transaction_count
10 FROM transactions
11 GROUP BY FLOOR(LOG10(amount));

Mengelompokkan transaksi berdasarkan order of magnitude.

Hasil

amount_range	transaction_count
Thousands	5200
Ten Thousands	12500
Hundred Thousands	8300
Millions	1500

Decibel Calculation

SQL

1 SELECT
2   signal_power,
3   reference_power,
4   10 * LOG10(signal_power / reference_power) as decibels
5 FROM signal_measurements;

Menghitung decibel menggunakan rumus 10 * log10(P/Pref).

Hasil

signal_power	reference_power	decibels
100	1	20.0
1000	1	30.0
0.01	1	-20.0

Fungsi Terkait

EXPLNLOGLOG2

Kembali ke DuckDB Functions

1	SELECT
2	value,
3	LOG10(value) as log10_val,
4	FLOOR(LOG10(value)) as magnitude
5	FROM (
6	SELECT unnest([5, 50, 500, 5000, 50000]) as value
7	);

1	SELECT
2	CASE FLOOR(LOG10(amount))
3	WHEN 3 THEN 'Thousands'
4	WHEN 4 THEN 'Ten Thousands'
5	WHEN 5 THEN 'Hundred Thousands'
6	WHEN 6 THEN 'Millions'
7	ELSE 'Other'
8	END as amount_range,
9	COUNT(*) as transaction_count
10	FROM transactions
11	GROUP BY FLOOR(LOG10(amount));

1	SELECT
2	signal_power,
3	reference_power,
4	10 * LOG10(signal_power / reference_power) as decibels
5	FROM signal_measurements;