</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “Relationships & missing data”

Small, practical examples. Search by task or narrow things down below.

639 snippets foundClear filters
SQLRelationships & missing data

Pair employees with their managers

SQL: Alias a table twice to represent two different roles in one relationship.

SQL✓ Tested
SQL ServerRelationships & missing data

Pair employees with their managers

SQL Server: Alias a table twice to represent two different roles in one relationship.

SQL Server✓ Tested
PostgresRelationships & missing data

Pair employees with their managers

Postgres: Alias a table twice to represent two different roles in one relationship.

Postgres✓ Tested
SQLiteRelationships & missing data

Pair employees with their managers

SQLite: Alias a table twice to represent two different roles in one relationship.

SQLite✓ Tested
SQLGetting Started

Display a fallback for missing data

SQL: Return a supplied label when a column contains NULL.

SQL✓ Tested
SQL ServerGetting Started

Display a fallback for missing data

SQL Server: Return a supplied label when a column contains NULL.

SQL Server✓ Tested
PostgresGetting Started

Display a fallback for missing data

Postgres: Return a supplied label when a column contains NULL.

Postgres✓ Tested
SQLiteGetting Started

Display a fallback for missing data

SQLite: Return a supplied label when a column contains NULL.

SQLite✓ Tested
C#Collections & data structures

Find values missing from another collection

C#: Except removes duplicates as it calculates the set difference.

C#✓ Tested
SQLChange & combine data

Test missing values with IS NULL

Find rows where an optional value is absent.

IS NULL✓ Tested
SQLGetting Started

Find missing values with IS NULL

SQL: Use IS NULL rather than equality to test for missing data.

SQL✓ Tested
SQL ServerGetting Started

Find missing values with IS NULL

SQL Server: Use IS NULL rather than equality to test for missing data.

SQL Server✓ Tested