Results for “--rm”

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

CStrings & byte buffers

Compare binary buffers including zero bytes ↗

C: memcmp checks an explicit byte length rather than stopping at a string terminator.

C✓ Tested

CStrings & byte buffers

Compare two C strings for equality ↗

C: strcmp returns zero only when both null-terminated byte strings are equal.

C✓ Tested

SQLJoins & subqueries

Compare with a calculated value ↗

Find products above the average price.

subquery✓ Tested

Linux CommandsArchives & checksums

Compress a file and keep the original ↗

Create a gzip-compressed copy of a file while leaving the uncompressed original in place.

gzip✓ Tested

SQLiteTables & writes

Compute a generated column ↗

Store inputs and derive a value from them.

generated column✓ Tested

CNumeric parsing & arithmetic

Compute a two-dimensional vector length ↗

C: hypot avoids unnecessary intermediate overflow compared with squaring both inputs directly.

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