Results for “base”

SQLWindow analytics

Calculate a cumulative integer percentage ↗

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

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

SQLGetting Started

Calculate a total for each group ↗

SQL: Group nonmissing categories and calculate separate totals.

SQL✓ Tested

SQL ServerGetting Started

Calculate a total for each group ↗

SQL Server: Group nonmissing categories and calculate separate totals.

SQL Server✓ Tested

SQLGetting Started

Calculate a value with SELECT ↗

SQL: Evaluate a small arithmetic expression on the database server.

SQL✓ Tested

SQL ServerGetting Started

Calculate a value with SELECT ↗

SQL Server: Evaluate a small arithmetic expression on the database server.

SQL Server✓ Tested

PostgresGetting Started

Calculate a value with SELECT ↗

Postgres: Evaluate a small arithmetic expression on the database server.

Postgres✓ Tested

SQLiteGetting Started

Calculate a value with SELECT ↗

SQLite: Evaluate a small arithmetic expression on the database server.

SQLite✓ Tested

SQLReporting & grouped calculations

Calculate each group’s integer percentage of the total ↗

SQL: Multiply before division and protect against a zero denominator.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Calculate each group’s integer percentage of the total ↗

SQL Server: Multiply before division and protect against a zero denominator.

SQL Server✓ Tested