Math

CEILING

DuckDB

Membulatkan angka ke atas ke integer terdekat. Alias dari CEIL dengan nama yang lebih eksplisit.

Tipe hasil: BIGINTDiperbarui: 6 Jan 2026

Syntax

SQL

CEILING(number) | CEIL(number)

Parameter

numberDOUBLE/DECIMALwajib

Angka yang akan dibulatkan ke atas

Contoh Penggunaan

Pembulatan ke Atas

SQL

1 SELECT
2   value,
3   CEILING(value) as ceiling_val,
4   FLOOR(value) as floor_val
5 FROM (
6   SELECT unnest([3.2, 3.8, -3.2, -3.8, 5.0]) as value
7 );

Membandingkan CEILING dengan FLOOR.

Hasil

value	ceiling_val	floor_val
3.2	4	3
3.8	4	3
-3.2	-3	-4
-3.8	-3	-4
... 1 baris lainnya

Menghitung Jumlah Halaman

SQL

1 SELECT
2   total_items,
3   items_per_page,
4   CEILING(total_items::DOUBLE / items_per_page) as total_pages
5 FROM (
6   SELECT 95 as total_items, 10 as items_per_page UNION ALL
7   SELECT 100, 10 UNION ALL
8   SELECT 101, 10
9 );

Menghitung jumlah halaman yang dibutuhkan untuk pagination.

Hasil

total_items	items_per_page	total_pages
95	10	10
100	10	10
101	10	11

Pricing dengan Markup

SQL

1 SELECT
2   product_name,
3   cost_price,
4   CEILING(cost_price * 1.25 / 1000) * 1000 as selling_price
5 FROM products;

Menghitung harga jual dengan markup 25%, dibulatkan ke ribuan atas.

Hasil

product_name	cost_price	selling_price
Widget A	45000	57000
Widget B	78500	99000
Widget C	123000	154000

Fungsi Terkait

ROUNDCEILFLOORTRUNC

Kembali ke DuckDB Functions

1	SELECT
2	value,
3	CEILING(value) as ceiling_val,
4	FLOOR(value) as floor_val
5	FROM (
6	SELECT unnest([3.2, 3.8, -3.2, -3.8, 5.0]) as value
7	);

1	SELECT
2	total_items,
3	items_per_page,
4	CEILING(total_items::DOUBLE / items_per_page) as total_pages
5	FROM (
6	SELECT 95 as total_items, 10 as items_per_page UNION ALL
7	SELECT 100, 10 UNION ALL
8	SELECT 101, 10
9	);

1	SELECT
2	product_name,
3	cost_price,
4	CEILING(cost_price * 1.25 / 1000) * 1000 as selling_price
5	FROM products;