å¯ä»¥ä½¿ç¨CEILING()å½æ°åFLOOR()å½æ°ï¼å¤çæ£æ°å¯ä»¥ä½¿ç¨åè
ï¼è´æ°å¯ä»¥ä½¿ç¨åè
ãè¯·æ ¹æ®å®é
éæ±æ¥éæ©ã
ä¸é¢æ¯è¿ä¸¤ä¸ªå½æ°ç说æï¼
CEILING
è¿å大äºæçäºæç»æ°å表达å¼çæå°æ´æ°ã
è¯æ³
CEILING ( numeric_expression )
åæ°
numeric_expression
æ¯ç²¾ç¡®æ°åæè¿ä¼¼æ°åæ°æ®ç±»åç±»å«ç表达å¼ï¼bit æ°æ®ç±»åé¤å¤ï¼ã
è¿åç±»å
è¿åä¸ numeric_expression ç¸åçç±»åã
示ä¾
ä¸é¢ç示ä¾æ¾ç¤ºä½¿ç¨ CEILING å½æ°çæ£æ°ãè´æ°åé¶å¼ã
SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0)
GO
ä¸é¢æ¯ç»æéï¼
--------- --------- -------------------------
124.00 -123.00 0.00
(1 row(s) affected)
FLOOR
è¿åå°äºæçäºæç»æ°å表达å¼çæ大æ´æ°ã
è¯æ³
FLOOR ( numeric_expression )
åæ°
numeric_expression
精确æ°åæè¿ä¼¼æ°åæ°æ®ç±»åç±»å«ç表达å¼ï¼bit æ°æ®ç±»åé¤å¤ï¼ã
è¿åç±»å
è¿åä¸ numeric_expression ç¸åçç±»åã
示ä¾
æ¤ç¤ºä¾è¯´ææ£æ°ãè´æ°åè´§å¸å¼å¨ FLOOR å½æ°ä¸çè¿ç¨ã
SELECT FLOOR(123.45), FLOOR(-123.45), FLOOR($123.45)
ç»æä¸ºä¸ numeric_expression æ°æ®ç±»åç¸åç计ç®å¼çæ´æ°é¨åã
--------- --------- -----------
123 -124 123.0000
温馨提示:答案为网友推荐,仅供参考