Results for “active low”

SQLSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQL: A CASE ordering key expresses business priority before a stable secondary sort.

SQL✓ Tested

SQL ServerSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQL Server: A CASE ordering key expresses business priority before a stable secondary sort.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

Postgres: A CASE ordering key expresses business priority before a stable secondary sort.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Sort preferred rows ahead of other rows ↗

SQLite: A CASE ordering key expresses business priority before a stable secondary sort.

SQLite✓ Tested

SQLGetting Started

Sort the highest quantities first ↗

SQL: Specify descending order and a stable tie breaker.

SQL✓ Tested

SQL ServerGetting Started

Sort the highest quantities first ↗

SQL Server: Specify descending order and a stable tie breaker.

SQL Server✓ Tested

PostgresGetting Started

Sort the highest quantities first ↗

Postgres: Specify descending order and a stable tie breaker.

Postgres✓ Tested

SQLiteGetting Started

Sort the highest quantities first ↗

SQLite: Specify descending order and a stable tie breaker.

SQLite✓ Tested

PythonStrings & dates

Split a string into words ↗

Split text on whitespace, automatically treating repeated spaces, tabs, and line breaks as a single separator.

string✓ Tested

JavaScriptArray restructuring

Split an array into bounded batches ↗

JavaScript: Advance by a positive batch size and allow a shorter final chunk.

JavaScript✓ Tested

TypeScriptArray restructuring

Split an array into bounded batches ↗

TypeScript: Advance by a positive batch size and allow a shorter final chunk.

TypeScript✓ Tested

SQL ServerDates & text

Split delimited text with positions ↗

Retain original order with STRING_SPLIT ordinals.

STRING_SPLIT✓ Tested