Does Not Equal Operator

The does not equal operator is a filtering operator that excludes a single attribute value. This operator can also be used to define the filter condition where two attributes have different values.

Syntax

SELECT … WHERE … <> …
SELECT metric WHERE attribute <> attribute_value
SELECT metric WHERE attribute1 <> attribute2

Examples

SELECT Revenues WHERE Year <> 2006
SELECT Amount WHERE Date_Ordered <> Date_Shipped