Results for “exec form”

PowerShellFiles & paths

Build a portable file path ↗

Combine directory and filename using the platform separator.

Join-Path✓ Tested

SQL ServerSubqueries & ranked selection

Build a query from several named stages ↗

SQL Server: Separate row selection from aggregation using two common table expressions.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Build a query from several named stages ↗

Postgres: Separate row selection from aggregation using two common table expressions.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Build a query from several named stages ↗

SQLite: Separate row selection from aggregation using two common table expressions.

SQLite✓ Tested

SQL ServerWindow analytics

Calculate a cumulative integer percentage ↗

SQL Server: Divide a running window sum by the complete total using a unique ordering key.

SQL Server✓ Tested

PostgresWindow analytics

Calculate a cumulative integer percentage ↗

Postgres: Divide a running window sum by the complete total using a unique ordering key.

Postgres✓ Tested

SQLiteWindow analytics

Calculate a cumulative integer percentage ↗

SQLite: Divide a running window sum by the complete total using a unique ordering key.

SQLite✓ Tested

PostgresWindows & text

Calculate a running total ↗

Accumulate values in row order.

window✓ Tested

JavaEncoding & structured values

Calculate a SHA-256 content digest ↗

Java: Hash UTF-8 bytes and format the result as lowercase hexadecimal.

Java✓ Tested

SQL ServerGetting Started

Calculate a total for each group ↗

SQL Server: Group nonmissing categories and calculate separate totals.

SQL Server✓ Tested

PostgresGetting Started

Calculate a total for each group ↗

Postgres: Group nonmissing categories and calculate separate totals.

Postgres✓ Tested

SQLiteGetting Started

Calculate a total for each group ↗

SQLite: Group nonmissing categories and calculate separate totals.

SQLite✓ Tested