SIGN (Azure Cosmos DB)SIGN (Azure Cosmos DB)

适用于: SQL API

返回指定数值表达式的正数 (+1)、零 (0) 或负数 (-1)。Returns the positive (+1), zero (0), or negative (-1) sign of the specified numeric expression.

语法Syntax

SIGN(<numeric_expr>)  

参数Arguments

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

返回类型Return types

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

示例Examples

以下示例返回数字 -2 到 2 的 SIGN 值。The following example returns the SIGN values of numbers from -2 to 2.

SELECT SIGN(-2) AS s1, SIGN(-1) AS s2, SIGN(0) AS s3, SIGN(1) AS s4, SIGN(2) AS s5  

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

[{s1: -1, s2: -1, s3: 0, s4: 1, s5: 1}]  

备注Remarks

此系统函数不会使用索引。This system function will not utilize the index.

后续步骤Next steps