This topic describes how to use the mathematical function subtraction in Realtime Compute.

Syntax

A - B

Input parameters

Parameter Data type
A INT
B INT

Description

Returns the result of A minus B.

Example

  • Test data
    int1 (INT) int2 (INT) int3 (INT)
    10 10 30
  • Test statements
    SELECT int3 - int2 - int1 as aa
    FROM T1;                  
  • Test results
    aa (INT)
    10