Results for “form”

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

Bash ScriptsParameter expansion

Convert a variable to uppercase ↗

Bash Scripts: Double caret transforms matching lowercase characters in Bash 4 or later.

Bash Scripts✓ Tested

JavaEncoding & structured values

Convert bytes to hexadecimal and back ↗

Java: Use HexFormat for a standard-library representation of raw bytes.

Java✓ 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