Results for “result”

PostgresRelationships & missing data

Find parents with at least two child rows ↗

Postgres: Use a correlated count when testing a per-parent threshold.

Postgres✓ Tested

SQLiteRelationships & missing data

Find parents with at least two child rows ↗

SQLite: Use a correlated count when testing a per-parent threshold.

SQLite✓ Tested

SQLRelationships & missing data

Find records without any related rows ↗

SQL: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL✓ Tested

SQL ServerRelationships & missing data

Find records without any related rows ↗

SQL Server: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL Server✓ Tested

PostgresRelationships & missing data

Find records without any related rows ↗

Postgres: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

Postgres✓ Tested

SQLiteRelationships & missing data

Find records without any related rows ↗

SQLite: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQLite✓ Tested

SQLJoins & subqueries

Find rows with a related record ↗

Use EXISTS without duplicating the outer rows.

EXISTS✓ 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

JavaStream transformations

Find the first matching stream value ↗

Java: Use findFirst and an explicit default for an empty result.

Java✓ 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