What are the two results?
-- SQLite SELECT NULL OR 1, NULL AND 0;
- NULL | NULL
- 1 | 0
- NULL | 0
- 1 | NULL
Three-valued logic: unknown OR true is true, and unknown AND false is false, regardless of the unknown.
Play SQL & Databases ▸
-- SQLite SELECT NULL OR 1, NULL AND 0;