Results for “Relationships & missing data”

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

SQL ServerDates & text

Split delimited text with positions ↗

Retain original order with STRING_SPLIT ordinals.

STRING_SPLIT✓ Tested

CDynamic memory & ownership

Store a variable-length payload after a structure header ↗

C: A flexible array member lets one allocation hold metadata and trailing bytes.

C✓ Tested

HTMLForm behavior

Submit a readonly value while preventing edits ↗

HTML: Readonly controls remain in form data, unlike disabled controls.

HTML✓ Tested

SQL ServerSelect & page

Substitute a value for NULL ↗

Use SQL Server’s ISNULL expression.

ISNULL✓ Tested

SQLWindow analytics

Sum a row and its immediate predecessor ↗

SQL: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

SQL✓ Tested

SQL ServerWindow analytics

Sum a row and its immediate predecessor ↗

SQL Server: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

SQL Server✓ Tested