This topic describes how to use the logical function <> in Realtime Compute.

Syntax

 A <> B

Input parameters

Parameter Data type
A TIMESTAMP, BIGINT, INT, VARCHAR, or DECIMAL
B TIMESTAMP, BIGINT, INT, VARCHAR, or DECIMAL

Description

If A is not equal to B, true is returned. Otherwise, false is returned.

Example

  • Test data
    int1 (INT) int2 (INT) int3 (INT)
    97 66 6
  • Test statements
    SELECT int1 as aa
    FROM T1
    WHERE int3 <> int2;
  • Test results
    aa (INT)
    97