Skip to main content

Comparison Operators

SQL Comparison Operators.

OperatorDescriptionExampleResult
=a is equal to b2 = 2TRUE
!=a is not equal to b2 != 3TRUE
<>a is not equal to b2 <> 2FALSE
>a is greater than b2 > 3FALSE
>=a is greater than or equal to b4 >= NULLNULL
<a is less than b2 < 3TRUE
<=a is less than or equal to b2 <= 3TRUE

IS (NOT) NULL

OperatorDescriptionExampleResult
expression IS NULLTRUE if expression is NULL, FALSE otherwise(4>= NULL) IS NULLTRUE
expression IS NOT NULLFALSE if expression is NULL, TRUE otherwise(4>= NULL) IS NOT NULLFALSE