</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “array_agg”

Small, practical examples. Search by task or narrow things down below.

198 snippets foundClear filters
SQLiteJSON data

Expand a JSON array into rows

Iterate array elements using a table-valued function.

json_each✓ Tested
PostgresJSON & arrays

Expand an array into rows

Use WITH ORDINALITY to retain original element order.

unnest✓ Tested
SQLExpressions & aggregates

Filter aggregate groups

Keep only categories with multiple products.

HAVING✓ Tested
CArray transformations

Filter an array in place with a write index

C: Only retained values advance the write position.

C✓ Tested
TypeScriptCollections & records

Filter and transform an array

Keep active objects and extract their names.

filter✓ Tested
SQLGetting Started

Filter groups after aggregation

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

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