Operators

a = b  -- a equal to b
a <> b -- a not equal to b
a > b  -- a is greater than b
a < b  -- a is less than b

a != b -- a is not equal to b -- BUT YOU WILL GET HATE FOR DOING THIS

Null comparisons

Note: You cannot compare to NULL , if you do you will always get false… so do this instead

WHERE a IS NULL
WHERE a IS NOT NULL