Know Your Nulls
9 hours ago
- #NULL values
- #PostgreSQL
- #SQL
- The article discusses SQL NULLs and includes a quiz inspired by the WAT talk.
- Examples provided are based on Postgres, but other RDBMSs may have slight differences.
- The quiz aims to highlight NULL semantics in SQL.
- There is an 'employees' table with columns: id, name, and manager_id.
- A query is shown: SELECT id, name FROM employees WHERE manager_id != 1;