Any comparison with null
is false - =
and <>
, >
, <
, and so on. You cannot use null
in an IN
list as well - it would be ignored. Moreover, two null
s are not even equal to each othe
Any comparison with null
is false - =
and <>
, >
, <
, and so on. You cannot use null
in an IN
list as well - it would be ignored. Moreover, two null
s are not even equal to each othe