The NULLIF statement

The IF statement evaluates a condition to be true or false and returns the appropriate value. Timestream supports the following two syntax representations for IF:

NULLIF returns null if value1 equals value2; otherwise it returns value1. The syntax is as follows:

nullif(value1, value2)