Math

ROUND

MySQL

Membulatkan angka ke jumlah desimal tertentu. Default tanpa desimal (ke integer terdekat).

Tipe hasil: DECIMAL/DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

ROUND(x [, d])

xnumericwajib

Angka yang akan dibulatkan

dintegeropsional

Jumlah digit desimal (default 0, bisa negatif)

Default: 0

SQL

1 SELECT ROUND(2.4) AS r1, ROUND(2.5) AS r2, ROUND(2.6) AS r3;

Pembulatan ke integer terdekat.

Hasil

r1: 2, r2: 3, r3: 3

SQL

1 SELECT ROUND(3.14159, 2) AS pi_rounded;

Bulatkan ke 2 desimal.

Hasil

pi_rounded: 3.14

SQL

1 SELECT product, price,
2   ROUND(price, -2) AS price_hundreds
3 FROM products;

Bulatkan ke ratusan terdekat.

Hasil

(prices rounded to nearest hundred)

1	SELECT product, price,
2	ROUND(price, -2) AS price_hundreds
3	FROM products;