Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 18, 2022
Send us feedback
!=
Returns true if expr1 does not equal expr2, or false otherwise.
true
expr1
expr2
false
expr1 != expr2
expr1: An expression of any comparable type.
expr2: An expression that shares a least common type with expr1.
A BOOLEAN.
This function is a synonym for <> (lt gt sign) operator.
> SELECT 2 != 2; false > SELECT 3 != 2; true > SELECT 1 != '1'; false > SELECT true != NULL; NULL > SELECT NULL != NULL; NULL
< (lt sign) operator
<= (lt eq sign) operator
> (gt sign) operator
>= (gt eq sign) operator
<=> (lt eq gt sign) operator
= (eq sign) operator
<> (lt gt sign) operator
SQL data type rules