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

Материал из SQL эксперт
Версия от 13:24, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

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

   <source lang="sql">

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


                    399

(1 rows affected) 1></source>


MAX(CEILING(price))

   <source lang="sql">

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</source>


select CEILING (1.25)

   <source lang="sql">

2> select CEILING (1.25) 3> GO


   2

(1 rows affected)</source>


select CEILING(-1.25) (Minus)

   <source lang="sql">

3> select CEILING(-1.25) 4> GO


  -1

(1 rows affected) 1></source>