What does the query return?
-- t.x: 5, NULL, 7 SELECT COUNT(*) FROM t WHERE x <> 5;
- 1
- 2
- 3
- 0
NULL <> 5 is unknown, not true, so only the row with 7 passes the filter.-- t.x: 5, NULL, 7 SELECT COUNT(*) FROM t WHERE x <> 5;
NULL <> 5 is unknown, not true, so only the row with 7 passes the filter.