Math

FLOOR

MySQL

Membulatkan angka ke bawah ke integer terdekat. Kebalikan dari CEIL.

Tipe hasil: BIGINTDiperbarui: 7 Jan 2026

Syntax

SQL

FLOOR(x)

xnumericwajib

Angka yang akan dibulatkan ke bawah

SQL

1 SELECT FLOOR(4.9) AS down1, FLOOR(-4.1) AS down2;

4.9 jadi 4, -4.1 jadi -5.

Hasil

down1: 4, down2: -5

SQL

1 SELECT FLOOR(age / 10) * 10 AS age_group,
2   COUNT(*) AS count
3 FROM users
4 GROUP BY FLOOR(age / 10)
5 ORDER BY age_group;

Mengelompokkan umur per dekade.

Hasil

(users grouped by decade)

SQL

1 SELECT product, price, discount_pct,
2   FLOOR(price * discount_pct / 100) AS discount_amount
3 FROM products;

Diskon dibulatkan ke bawah.

Hasil

(discount rounded down)

1	SELECT product, price, discount_pct,
2	FLOOR(price * discount_pct / 100) AS discount_amount
3	FROM products;