SQL Server/T-SQL Tutorial/Math Functions/CEILING

CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number.

3>
4>
5> SELECT CEILING(SQRT(2.0*ABS(1985.0)*ABS(-8.0)/ABS(0.20)))
6> GO
------------------------
                     399
(1 rows affected)
1>

MAX(CEILING(price))

3> CREATE TABLE titles(
4>    title_id       varchar(20),
5>    title          varchar(80)       NOT NULL,
6>    type           char(12)          NOT NULL,
7>    pub_id         char(4)               NULL,
8>    price          money                 NULL,
9>    advance        money                 NULL,
10>    royalty        int                   NULL,
11>    ytd_sales      int                   NULL,
12>    notes          varchar(200)          NULL,
13>    pubdate        datetime          NOT NULL
14> )
15> GO
1>
2> insert titles values ("1", "Secrets",   "popular_comp", "1389", $20.00, $8000.00, 10, 4095,"Note 1","06/12/94")
3> insert titles values ("2", "The",       "business",     "1389", $19.99, $5000.00, 10, 4095,"Note 2","06/12/91")
4> insert titles values ("3", "Emotional", "psychology",   "0736", $7.99,  $4000.00, 10, 3336,"Note 3","06/12/91")
5> insert titles values ("4", "Prolonged", "psychology",   "0736", $19.99, $2000.00, 10, 4072,"Note 4","06/12/91")
6> insert titles values ("5", "With",      "business",     "1389", $11.95, $5000.00, 10, 3876,"Note 5","06/09/91")
7> insert titles values ("6", "Valley",    "mod_cook",     "0877", $19.99, $0.00,    12, 2032,"Note 6","06/09/91")
8> insert titles values ("7", "Any?",      "trad_cook",    "0877", $14.99, $8000.00, 10, 4095,"Note 7","06/12/91")
9> insert titles values ("8", "Fifty",     "trad_cook",    "0877", $11.95, $4000.00, 14, 1509,"Note 8","06/12/91")
10> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2>
3> SELECT "Low End"=MIN(FLOOR(price)),
4>     "High End"=MAX(CEILING(price))
5> FROM titles
6> GO
Low End               High End
--------------------- ---------------------
               7.0000               20.0000
(1 rows affected)
1>
2> drop table titles;
3> GO

select CEILING (1.25)

2> select CEILING (1.25)
3> GO
-----
    2
(1 rows affected)

select CEILING(-1.25) (Minus)

3> select CEILING(-1.25)
4> GO
-----
   -1
(1 rows affected)
1>