MySQL CEILING() Function

 The CEILING() function in MySQL is used to return the smallest integer value that is greater than or equal to a given number. It essentially "rounds up" the value, regardless of whether the decimal part is small or large.

Syntax:

CEILING(number)

• number: The numeric value for which you want to find the ceiling.

How it works:

• If the number is already an integer, CEILING() returns the number itself.
• If the number has a decimal part, it rounds the number up to the next largest integer.

Example Usage:

Example 1: Basic Usage

SELECT CEILING(4.2);

Output: 5

Example 2: Rounding a Negative Number

SELECT CEILING(-4.2);

Output: -4

Example 3: Integer Input (No Effect)

SELECT CEILING(10);

Output: 10

Example 4: Rounding Positive Decimal

SELECT CEILING(5.75);

Output: 6

Key Points:

• The CEILING() function always rounds up.
• It works with both positive and negative numbers:
  • For positive numbers, it rounds up to the next whole number.
  • For negative numbers, it rounds toward zero, i.e., towards the smaller magnitude.

Common Use Cases:

• Rounding monetary values to the next whole number (e.g., when calculating the total cost of something and you need to ensure the result is rounded up).
• When allocating resources (e.g., pages, teams, etc.), ensuring that any fractional value results in rounding up to the next available unit.

Let me know if you need more detailed examples or any specific use cases!