SUB - Mathematical
Subtracts x from y
Input parameters
| Name | Type | Optional | Description |
|---|---|---|---|
x |
Number | False | |
y |
Number | False |
Output
Number: x - y
Usage
SUB(<x>, <y>)
Examples
Example 1
Query
LOAD tmp
AS ('': SUB(3, 1))
Result
2
Example 2
Query
LOAD tmp
AS ('': SUB(-5, 12.4))
Result
-17.4