Results for “base”

CSSBox dimensions & overflow

Size a child relative to its containing block ↗

CSS: A percentage width is based on the containing block’s available width.

CSS✓ Tested

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

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

PostgresWindow analytics

Sum a row and its immediate predecessor ↗

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

Postgres✓ Tested