Results for “equality”
Small, practical examples. Search by task or narrow things down below.
Create an index matching filter and ordering columns
SQLite: Place the equality-filter column before the ordering column in this composite index.
SQLite✓ Tested
Find missing values with IS NULL
SQL: Use IS NULL rather than equality to test for missing data.
SQL✓ Tested
Find missing values with IS NULL
SQL Server: Use IS NULL rather than equality to test for missing data.
SQL Server✓ Tested
Find missing values with IS NULL
Postgres: Use IS NULL rather than equality to test for missing data.
Postgres✓ Tested
Find missing values with IS NULL
SQLite: Use IS NULL rather than equality to test for missing data.
SQLite✓ Tested
Include missing values in a not-equal filter
SQL: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQL✓ Tested
Include missing values in a not-equal filter
SQL Server: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQL Server✓ Tested
Include missing values in a not-equal filter
Postgres: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
Postgres✓ Tested
Include missing values in a not-equal filter
SQLite: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQLite✓ Tested
Match one of several values
Use IN to avoid repeating equality conditions.
IN✓ Tested
Remove duplicate values with a Set
Keep the first occurrence order while deduplicating.
Set✓ Tested
Require every bit in a mask
Arduino / C: Masking followed by equality tests whether all required flags are set.
Arduino / C✓ Tested