Returns the smallest integer not less than x (ceiling).
Syntax
CEIL(x)Example
Enter values below to update the example in real time.
order_id→total_amount→shipping_fee→orders→-- 배송비 올림 계산
SELECT order_id, CEIL(total_amount * 0.03) AS shipping_fee
FROM orders;