Results for “header”

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

SQLiteWindow analytics

Sum a row and its immediate predecessor ↗

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

SQLite✓ Tested

SQLExpressions & aggregates

Sum values per category ↗

Calculate a grouped total.

SUM✓ Tested

SQLChange & combine data

Test missing values with IS NULL ↗

Find rows where an optional value is absent.

IS NULL✓ Tested

SQLText cleanup & matching

Treat an empty trimmed value as missing ↗

SQL: NULLIF converts an empty string to NULL before a fallback is applied.

SQL✓ Tested

SQL ServerText cleanup & matching

Treat an empty trimmed value as missing ↗

SQL Server: NULLIF converts an empty string to NULL before a fallback is applied.

SQL Server✓ Tested

PostgresText cleanup & matching

Treat an empty trimmed value as missing ↗

Postgres: NULLIF converts an empty string to NULL before a fallback is applied.

Postgres✓ Tested

SQLiteText cleanup & matching

Treat an empty trimmed value as missing ↗

SQLite: NULLIF converts an empty string to NULL before a fallback is applied.

SQLite✓ Tested

SQLGetting Started

Turn a condition into a result label ↗

SQL: Use CASE to describe stock availability for each row.

SQL✓ Tested