Results for “aggregate”

C#LINQ transformations

Calculate a product with Aggregate ↗

C#: Supply a seed to define the result for an empty sequence.

C#✓ Tested

SQLExpressions & aggregates

Filter aggregate groups ↗

Keep only categories with multiple products.

HAVING✓ Tested

SQLRelationships & missing data

Join a parent to pre-aggregated totals ↗

SQL: Aggregate the child rows first to produce at most one joined row per parent.

SQL✓ Tested

SQL ServerRelationships & missing data

Join a parent to pre-aggregated totals ↗

SQL Server: Aggregate the child rows first to produce at most one joined row per parent.

SQL Server✓ Tested

PostgresRelationships & missing data

Join a parent to pre-aggregated totals ↗

Postgres: Aggregate the child rows first to produce at most one joined row per parent.

Postgres✓ Tested

SQLiteRelationships & missing data

Join a parent to pre-aggregated totals ↗

SQLite: Aggregate the child rows first to produce at most one joined row per parent.

SQLite✓ Tested

SQLiteJSON data

Build a JSON array from rows ↗

Aggregate ordered text values into JSON.

json_group_array✓ Tested

PostgresJSON & arrays

Collect ordered values into an array ↗

Build a sorted array from query rows.

array_agg✓ Tested

SQLExpressions & aggregates

Count rows per category ↗

Aggregate rows sharing the same category.

GROUP BY✓ 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