!=

​

<expression> != <value>

​

Description

Implements the NOT EQUAL TO operator. <expression> can be <table>.<column> or AGG(<table>.<column>, <start>, <end>).

This operator can be applied to columns of all types. The constant data type needs to match the aggregation/column data type.

​

Example

LAST(LOAN.AMOUNT, 0, 30) != 0