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