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.