Results for “all”

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

C++Getting Started

Compare a value with a limit ↗

C++: Turn a comparison into a readable yes or no result.

C++✓ Tested

CGetting Started

Compare a value with a limit ↗

C: Turn a comparison into a readable yes or no result.

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

Bash ScriptsGetting Started

Compare two text values ↗

Bash Scripts: Compare two text values with a small standalone Bash program.

Bash Scripts✓ Tested

ReactComponents & props

Compose a component with named content slots ↗

Compose a component with named content slots with a small React component and explicit browser behavior.

React✓ Tested

ReactGetting Started

Compose content through children ↗

Compose content through children with a small React component and explicit browser behavior.

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

PostgresReporting & grouped calculations

Compute an integer weighted average ↗

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

Postgres✓ Tested