Results for “File operations & binary data”

PostgresGetting Started

Find missing values with IS NULL ↗

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

Postgres✓ Tested

SQLiteGetting Started

Find missing values with IS NULL ↗

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

SQLite✓ Tested

SQLJoins & subqueries

Find rows with a related record ↗

Use EXISTS without duplicating the outer rows.

EXISTS✓ Tested

GitCommits & history

Find the commit responsible for a line ↗

Inspect line attribution in a stable machine-readable format.

blame✓ Tested

SQL ServerDates & text

Find the final day of a month ↗

Use EOMONTH without manually calculating month length.

EOMONTH✓ Tested

SQLiteDates & time

Find the first day of a month ↗

Round a date to its calendar month boundary.

date✓ Tested

RustIterators & transformations

Find the first matching value ↗

Find the first matching value in a complete Rust program using the standard library.

Rust✓ Tested

jQueryTraversal & selection

Find the nearest matching ancestor ↗

Read a parent row attribute using jQuery closest.

jQuery✓ Tested

PowerShellDates & numeric validation

Find the number of days in a month ↗

PowerShell: DaysInMonth handles leap-year February correctly.

PowerShell✓ Tested

SQLSubqueries & ranked selection

Find the second-highest distinct value ↗

SQL: Select the maximum below the overall maximum to skip ties at the top.

SQL✓ Tested

SQL ServerSubqueries & ranked selection

Find the second-highest distinct value ↗

SQL Server: Select the maximum below the overall maximum to skip ties at the top.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Find the second-highest distinct value ↗

Postgres: Select the maximum below the overall maximum to skip ties at the top.

Postgres✓ Tested