MySQL CEILING function is one of the Numeric Functions, which returns the closest integer value that is greater than or equal to the specified expression.
The basic syntax of the CEIL or CEILING in MySQL is as shown below:
-- MySQL CEILING Function Syntax SELECT CEILING (Numeric_Expression) FROM Source -- MySQL CEILING Function Syntax SELECT CEIL (Numeric_Expression) FROM Source
To demonstrate the CEIL or CEILING Numeric function, we are going to use the below shown data
MySQL CEILING Function Example 1
The CEILING Function displays the closest integer value. The following query shows multiple ways to use the CEILING function.
-- MySQL CEILING Function Example -- Ceiling Function on Negative Value SELECT CEILING(-1150.01) AS `Ceiling Value`; -- Ceiling Function on Positive Value SELECT CEILING(125.07) AS `Ceiling Value`; -- Ceiling Function on string value SELECT CEILING('712.17') AS `Ceiling Value`; -- Ceiling Function on String SELECT CEILING('MySQL') AS `Ceiling Value`; -- Ceiling Function on NULLs SELECT CEILING('NULL') AS `Ceiling Value`;
From the below screenshot, you can see that we used CEILING function on different values.
MySQL CEIL Function Example
The MySQL CEIL Function is the synonym for the ceiling Numeric Function. The following query shows you the CEIL function examples.
-- MySQL CEIL Function Example -- Ceil Function on Negative Value SELECT CEIL(-19.91) AS `Ceil Value`; -- Ceil Function on Positive Value SELECT CEIL(25.02) AS `Ceil Value`; -- Ceil Function on string value SELECT CEIL('1415.19') AS `Ceil Value`;
From the screenshot below, you can see we used the CEIL function on different values.
MySQL CEILING Example 2
The MySQL CEILING or CEIL also allows you to find the closest value for the column data. In this MySQL example, we are going to find the closet integer values for all the records present in the Service Grade column.
-- MySQL CEILING Function Example or MySQL CEIL Function Example USE mysqltutorial; SELECT Product, Color, StandardCost, CEILING(StandardCost) AS Cost, Sales, CEILING(Sales) AS Sales, TaxAmt, CEIL(TaxAmt) AS Tax, ServiceGrade, CEIL(ServiceGrade) AS Grade FROM `numeric functions`;
OUTPUT
MySQL CEILING WHERE Clause Example
We can also use the CEIL or MySQL CEILING function in Where Clause as well. In this example, we use this CEIL function in where clause to restrict the records selected by the SELECT Statement.
-- MySQL CEILING Function Example or MySQL CEIL Function Example USE mysqltutorial; SELECT Product, Color, StandardCost, CEILING(StandardCost) AS Cost, Sales, CEILING(Sales) AS Sales, TaxAmt, CEIL(TaxAmt) AS Tax, ServiceGrade, CEIL(ServiceGrade) AS Grade FROM `numeric functions` WHERE CEILING(StandardCost) > 10000;
OUTPUT