Results for “Relationships & missing data”

RustFunctions & data types

Wrap a value in a distinct type ↗

Wrap a value in a distinct type in a complete Rust program using the standard library.

Rust✓ Tested

JavaFile operations & binary data

Write and read binary bytes ↗

Java: Use the byte-oriented Files methods when text encoding should not be involved.

Java✓ Tested

JavaEncoding & structured values

Write and read typed binary fields ↗

Java: Data streams use a matching write/read order and fixed encodings for Java primitive values.

Java✓ Tested

SQLGetting Started

Calculate a total for each group ↗

SQL: Group nonmissing categories and calculate separate totals.

SQL✓ Tested

SQL ServerGetting Started

Calculate a total for each group ↗

SQL Server: Group nonmissing categories and calculate separate totals.

SQL Server✓ Tested

SQLChange & combine data

Delete one matching row ↗

Remove a selected record and inspect what remains.

DELETE✓ Tested

TypeScriptSafe data handling

Read a nested optional value ↗

Avoid dereferencing a missing nested object.

optional chaining✓ Tested

SQLExpressions & aggregates

Replace NULL in a result ↗

Choose a fallback for a missing value.

COALESCE✓ Tested

SQLGetting Started

Accept either of two conditions ↗

SQL: Use OR to keep matching names or out-of-stock rows.

SQL✓ Tested

SQL ServerGetting Started

Accept either of two conditions ↗

SQL Server: Use OR to keep matching names or out-of-stock rows.

SQL Server✓ Tested

GitRestoring & revising local work

Add a forgotten file to the latest unpublished commit ↗

Git: Stage the missing file before amending without changing the message.

Git✓ Tested

PostgresDates & series

Add an interval to a date ↗

Perform calendar arithmetic with an interval literal.

INTERVAL✓ Tested