CEILING

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;