Math

CEIL

MySQL

Membulatkan angka ke atas ke integer terdekat. CEILING adalah sinonim.

Tipe hasil: BIGINTDiperbarui: 7 Jan 2026

Syntax

SQL

CEIL(x) | CEILING(x)

xnumericwajib

Angka yang akan dibulatkan ke atas

SQL

1 SELECT CEIL(4.2) AS up1, CEIL(4.8) AS up2;

Keduanya menjadi 5.

Hasil

up1: 5, up2: 5

SQL

1 SELECT total_items,
2   CEIL(total_items / 10.0) AS pages_needed
3 FROM search_results;

Menghitung halaman untuk pagination.

Hasil

(pages needed for pagination)

SQL

1 SELECT product, price * 1.1 AS with_tax,
2   CEIL(price * 1.1) AS rounded_price
3 FROM products;

Harga dengan pajak dibulatkan ke atas.

Hasil

(rounded up prices with tax)

1	SELECT total_items,
2	CEIL(total_items / 10.0) AS pages_needed
3	FROM search_results;

1	SELECT product, price * 1.1 AS with_tax,
2	CEIL(price * 1.1) AS rounded_price
3	FROM products;