Results for “header”

SQL ServerSubqueries & ranked selection

Compare a row with its own group average ↗

SQL Server: A correlated aggregate computes a different comparison value for each group.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Compare a row with its own group average ↗

Postgres: A correlated aggregate computes a different comparison value for each group.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Compare a row with its own group average ↗

SQLite: A correlated aggregate computes a different comparison value for each group.

SQLite✓ Tested

PostgresWindows & text

Compare a row with the previous row ↗

Read a preceding value with LAG.

LAG✓ Tested

SQLJoins & subqueries

Compare with a calculated value ↗

Find products above the average price.

subquery✓ Tested

SQLiteTables & writes

Compute a generated column ↗

Store inputs and derive a value from them.

generated column✓ Tested

SQLReporting & grouped calculations

Compute an integer weighted average ↗

SQL: Multiply before summing and guard a zero total weight with NULLIF.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Compute an integer weighted average ↗

SQL Server: Multiply before summing and guard a zero total weight with NULLIF.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Compute an integer weighted average ↗

Postgres: Multiply before summing and guard a zero total weight with NULLIF.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Compute an integer weighted average ↗

SQLite: Multiply before summing and guard a zero total weight with NULLIF.

SQLite✓ Tested

SQL ServerSelect & page

Convert text without raising a conversion error ↗

Return NULL when a numeric conversion fails.

TRY_CONVERT✓ Tested

SQLiteDates & time

Convert Unix time to a timestamp ↗

Interpret a seconds-since-epoch value as UTC.

unixepoch✓ Tested