In SQL Server, you may want to round up or round down a number to find the ceiling or floor value. You can use the CEILING and FLOOR function in SQL Server to achieve this.
How to Round Up or Round Down a Number in SQL Server?
Here’s a SQL query that demonstrates the usage of ROUND,CEILING and FLOOR function in SQL server.
DECLARE @input decimal(18,5) SET @input = 78.78912 SELECT CEILING(@input) CeilingValue SELECT FLOOR(@input) FloorValue SELECT ROUND(@input, 2) RoundValue
In the above query , we were successfully be able to use the CEILING and FLOOR function to get the rounded up or rounded down value. Remember that the CEILING function and FLOOR is very different from the ROUND function as the ROUND function uses the rounding(ceiling/floor) function under the hood.