Results for “empty”

SQL ServerBulk changes & set operations

Find rows in the first result but not the second ↗

SQL Server: EXCEPT calculates a distinct result-set difference.

SQL Server✓ Tested

PostgresBulk changes & set operations

Find rows in the first result but not the second ↗

Postgres: EXCEPT calculates a distinct result-set difference.

Postgres✓ Tested

SQL ServerBulk changes & set operations

Find rows shared by two query results ↗

SQL Server: INTERSECT compares complete selected rows and removes duplicates.

SQL Server✓ Tested

PostgresBulk changes & set operations

Find rows shared by two query results ↗

Postgres: INTERSECT compares complete selected rows and removes duplicates.

Postgres✓ Tested

SQL ServerDates & text

Find the final day of a month ↗

Use EOMONTH without manually calculating month length.

EOMONTH✓ Tested

JavaStream transformations

Find the first matching stream value ↗

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

Java✓ Tested

CArrays

Find the largest array value ↗

Track the maximum in a nonempty C integer array.

C✓ Tested

C++Numbers & algorithms

Find the largest value ↗

Check for an empty C++ vector before dereferencing max_element.

C++✓ 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

Bash ScriptsText parsing & arithmetic

Format a numeric label with leading zeroes ↗

Bash Scripts: Use a constant printf format string and supply values as separate arguments.

Bash Scripts✓ Tested

PostgresDates & series

Format a timestamp with to_char ↗

Produce a fixed numeric date string.

to_char✓ Tested