Results for “missing rows”
Small, practical examples. Search by task or narrow things down below.
Keep rows matching a condition
SQL: Use WHERE to select rows with a particular category.
SQL✓ Tested
Keep rows matching a condition
SQL Server: Use WHERE to select rows with a particular category.
SQL Server✓ Tested
Keep rows matching a condition
Postgres: Use WHERE to select rows with a particular category.
Postgres✓ Tested
Keep rows matching a condition
SQLite: Use WHERE to select rows with a particular category.
SQLite✓ Tested
Label rows with CASE
Derive a readable label from a condition.
CASE✓ Tested
Number rows within each group
Assign ordered row numbers with a window function.
row_number✓ Tested
Provide a default for a missing value
Provide a default for a missing value in a complete Rust program using the standard library.
Rust✓ Tested
Read CSV rows as dictionaries
Read a CSV file using its header row as dictionary keys, so each column can be accessed by name.
csv✓ Tested
Read rows from CSV text
Parse CSV into objects with named properties.
CSV✓ Tested
Reject a missing required configuration value
Bash Scripts: Check a required value explicitly and emit a controlled diagnostic before exiting.
Bash Scripts✓ Tested
Remove dependent rows with a declared cascade
SQL: ON DELETE CASCADE removes children when their referenced parent is deleted.
SQL✓ Tested
Remove dependent rows with a declared cascade
SQL Server: ON DELETE CASCADE removes children when their referenced parent is deleted.
SQL Server✓ Tested