Results for “Containers & compound values”
Small, practical examples. Search by task or narrow things down below.
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
Find values common to two collections
C#: Intersect returns distinct values shared by the inputs.
C#✓ Tested
Find values missing from another collection
Python: Use a set difference to identify requested IDs absent from the available IDs.
Python✓ Tested
Find values missing from another collection
C#: Except removes duplicates as it calculates the set difference.
C#✓ Tested
Find values present in exactly one set
Python: Use symmetric difference when either side can contain unmatched values.
Python✓ Tested
Find values shared by two collections
Python: Use set intersection and sort the result for deterministic display.
Python✓ Tested
Group matching values while preserving their order
C++: stable_partition keeps the relative order within both predicate groups.
C++✓ Tested
Group related values in nested structures
C: Nested members model a record that owns another simple record.
C✓ 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