CEILING (Azure Cosmos DB)CEILING (Azure Cosmos DB)

适用于： SQL API

返回大于或等于指定数值表达式的最小整数值。Returns the smallest integer value greater than, or equal to, the specified numeric expression.

语法Syntax

CEILING (<numeric_expr>)

参数Arguments

numeric_exprnumeric_expr
是一个数值表达式。Is a numeric expression.

返回类型Return types

返回一个数值表达式。Returns a numeric expression.

示例Examples

以下示例显示了如何对正值、负值和零值使用 CEILING 函数。The following example shows positive numeric, negative, and zero values with the CEILING function.

SELECT CEILING(123.45) AS c1, CEILING(-123.45) AS c2, CEILING(0.0) AS c3

下面是结果集。Here is the result set.

[{c1: 124, c2: -123, c3: 0}]

备注Remarks

此系统函数将从范围索引中获益。This system function will benefit from a range index.

后续步骤Next steps