Results for “display”

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

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