Results for “out”

Arduino / CText & bounded buffers

Compare a command case-sensitively ↗

Arduino / C: strcmp returns zero when both null-terminated strings match.

Arduino / C✓ Tested

SQLSubqueries & ranked selection

Compare a row with its own group average ↗

SQL: A correlated aggregate computes a different comparison value for each group.

SQL✓ Tested

SQL ServerSubqueries & ranked selection

Compare a row with its own group average ↗

SQL Server: A correlated aggregate computes a different comparison value for each group.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Compare a row with its own group average ↗

Postgres: A correlated aggregate computes a different comparison value for each group.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Compare a row with its own group average ↗

SQLite: A correlated aggregate computes a different comparison value for each group.

SQLite✓ Tested

PostgresWindows & text

Compare a row with the previous row ↗

Read a preceding value with LAG.

LAG✓ Tested

Arduino / CTiming & control

Compare elapsed time across timer rollover ↗

Use unsigned subtraction when a millisecond counter wraps.

rollover✓ Tested

Bash ScriptsInput streams & redirection

Compare two generated sorted streams ↗

Bash Scripts: Process substitution lets a command consume another command’s output as a file-like input.

Bash Scripts✓ Tested

SQLJoins & subqueries

Compare with a calculated value ↗

Find products above the average price.

subquery✓ Tested

SQLiteTables & writes

Compute a generated column ↗

Store inputs and derive a value from them.

generated column✓ Tested

SQLReporting & grouped calculations

Compute an integer weighted average ↗

SQL: Multiply before summing and guard a zero total weight with NULLIF.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Compute an integer weighted average ↗

SQL Server: Multiply before summing and guard a zero total weight with NULLIF.

SQL Server✓ Tested