Results for “#table”

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

Linux CommandsStreams & byte tools

Split a file into fixed line-count pieces ↗

Linux Commands: Use numeric suffixes for predictable filenames when splitting a large text file.

Linux Commands✓ Tested

Bash ScriptsVariables & text

Split a line into named fields ↗

Read a simple delimiter-separated line into variables.

read✓ Tested

PowerShellArray operations

Split an array into fixed-size batches ↗

PowerShell: Bound the final index so the last batch can contain fewer elements.

PowerShell✓ Tested

SQL ServerDates & text

Split delimited text with positions ↗

Retain original order with STRING_SPLIT ordinals.

STRING_SPLIT✓ Tested

PowerShellGetting Started

Split simple delimited text ↗

PowerShell: Split simple delimited text using PowerShell 7.

PowerShell✓ Tested