Math

ROUND

BigQuery

Membulatkan angka ke precision desimal yang ditentukan menggunakan rounding half away from zero.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

ROUND(expression [, precision])

expressionFLOAT64/NUMERIC/BIGNUMERICwajib

Nilai numerik untuk dibulatkan

precisionINT64opsional

Jumlah digit desimal (default: 0)

Default: 0

SQL

1 SELECT
2   value,
3   ROUND(value) as rounded,
4   ROUND(value, 1) as one_decimal
5 FROM UNNEST([1.234, 2.567, 3.999, -1.5]) as value;

Pembulatan ke integer dan satu desimal.

Hasil

SQL

1 SELECT
2   amount,
3   ROUND(amount, -2) as rounded_to_hundred
4 FROM UNNEST([1234, 5678, 9950]) as amount;

Membulatkan ke ratusan terdekat.

Hasil

1	SELECT
2	amount,
3	ROUND(amount, -2) as rounded_to_hundred
4	FROM UNNEST([1234, 5678, 9950]) as amount;