Results for “pre”

SQLExpressions & aggregates

Count rows per category ↗

Aggregate rows sharing the same category.

GROUP BY✓ Tested

SQLReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQL: SUM over CASE expressions calculates several conditional counts in one scan.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQL Server: SUM over CASE expressions calculates several conditional counts in one scan.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Count rows satisfying separate conditions ↗

Postgres: SUM over CASE expressions calculates several conditional counts in one scan.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQLite: SUM over CASE expressions calculates several conditional counts in one scan.

SQLite✓ Tested

C#File operations & paths

Create a file only when it does not exist ↗

C#: FileMode.CreateNew prevents accidental replacement of existing content.

C#✓ Tested

C#Types & reliable control flow

Create a modified copy of an immutable record ↗

C#: A with expression creates a shallow copy with selected changed properties.

C#✓ Tested

GitRestoring & revising local work

Create a recovery branch for a recently moved commit ↗

Git: The reflog can identify a previous local HEAD position while its entry and objects remain available.

Git✓ Tested

HTMLDocument structure

Create an ordered list ↗

Represent a sequence of steps using an HTML ordered list.

HTML✓ Tested

Arduino / CTiming & control

Debounce a button with a stable-time check ↗

Accept an input change only after it stays stable for 30 ms.

debounce✓ Tested

Docker / ComposeCompose applications

Declare a named volume in Compose ↗

Mount persistent storage at a service path.

Compose✓ Tested

HTMLForm behavior

Disable a related group of controls ↗

HTML: A disabled fieldset prevents editing its descendant controls and omits them from form submission.

HTML✓ Tested