Results for “json_group_array”

SQL ServerGetting Started

Filter groups after aggregation ↗

SQL Server: Use HAVING to test a group’s calculated total.

SQL Server✓ Tested

PostgresGetting Started

Filter groups after aggregation ↗

Postgres: Use HAVING to test a group’s calculated total.

Postgres✓ Tested

SQLiteGetting Started

Filter groups after aggregation ↗

SQLite: Use HAVING to test a group’s calculated total.

SQLite✓ Tested

SQLReporting & grouped calculations

Filter rows before grouping ↗

SQL: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Filter rows before grouping ↗

SQL Server: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Filter rows before grouping ↗

Postgres: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Filter rows before grouping ↗

SQLite: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.

SQLite✓ Tested

CArrays

Find an array element ↗

Use a bounded linear search over a C array.

C✓ Tested

JavaScriptArray traversal & selection

Find the first matching array item ↗

JavaScript: find returns undefined when no item satisfies the predicate.

JavaScript✓ Tested

TypeScriptArray traversal & selection

Find the first matching array item ↗

TypeScript: find returns undefined when no item satisfies the predicate.

TypeScript✓ Tested

PowerShellArray operations

Find the index of an array item ↗

PowerShell: Array.IndexOf returns -1 when the requested item is absent.

PowerShell✓ Tested

CArrays

Find the largest array value ↗

Track the maximum in a nonempty C integer array.

C✓ Tested