in table , if make following query
select * table order_id != 1 i think, supposed row no 18 & 19. instead, query can't not fetch row.
i can rewrite query
select * table (order_id != 1 or order_id null) and fetches expected data, should not first query being able fetch row no 18 & 19?
from docs
the null value can surprising until used it. conceptually, null means “a missing unknown value” , treated differently other values.
to test null, use is null , is not null operators
you cannot use arithmetic comparison operators such =, <, or <> test null.
because result of arithmetic comparison null null, cannot obtain meaningful results such comparisons.
