select CEILING (1.25) : CEILING « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. CEILING
2> select CEILING (1.25)
3> GO

-----
    2

(1 rows affected)








11.5.CEILING
11.5.1.CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number.
11.5.2.select CEILING(-1.25) (Minus)
11.5.3.select CEILING (1.25)
11.5.4.MAX(CEILING(price))