In SQL, NULL means "unknown value". Thus, every comparison with NULL yields NULL (unknown) rather than TRUE or FALSE. From a conceptional point of view, this three-valued logic makes sense. From a ...
I'm not sure of the right syntax to use. Is it select * from tlb where flag is NULL or select * from tlb where flag = NULL Is the answer the same for oracle, sqlserver and Postgres?