- (Subtract) (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Performs an arithmetic operation that subtracts one number from another number.

Syntax


Numeric_Expression - Numeric_Expression  

Parameters

Numeric_Expression
A valid Data Mining Extensions (DMX) expression that returns a numeric value.

Return Value

A value that has the data type of the parameter that has the higher precedence.

Remarks

Both expressions must be of the same data type, or one expression must be able to be implicitly converted to the data type of the other expression. If one expression evaluates to a null value, the operator returns the result of the other expression.

See Also

Arithmetic Operators (DMX)
Data Mining Extensions (DMX) Operator Reference
Operators (DMX)