CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number. : CEILING « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. CEILING
3>
4>
5> SELECT CEILING(SQRT(2.0*ABS(1985.0)*ABS(-8.0)/ABS(0.20)))
6> GO

------------------------
                     399

(1 rows affected)
1>








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))