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

Results for “query”

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

202 snippets foundClear filters
SQL ServerSubqueries & ranked selection

Attach an overall count to every row

SQL Server: An uncorrelated scalar subquery supplies the same aggregate to each output row.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Attach an overall count to every row

Postgres: An uncorrelated scalar subquery supplies the same aggregate to each output row.

Postgres✓ Tested
SQLiteSubqueries & ranked selection

Attach an overall count to every row

SQLite: An uncorrelated scalar subquery supplies the same aggregate to each output row.

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
SQLJoins & subqueries

Combine matching rows with INNER JOIN

Read product names with their matching stock values.

INNER JOIN✓ Tested
SQLChange & combine data

Combine results without duplicates

Merge compatible result sets with UNION.

UNION✓ Tested
SQLExpressions & aggregates

Count rows per category

Aggregate rows sharing the same category.

GROUP BY✓ Tested
SQLChange & combine data

Delete one matching row

Remove a selected record and inspect what remains.

DELETE✓ Tested
SQLSchema design & transactions

Enforce uniqueness with a dedicated index

SQL: A unique index rejects a duplicate combination independently of query plans.

SQL✓ Tested
SQL ServerSchema design & transactions

Enforce uniqueness with a dedicated index

SQL Server: A unique index rejects a duplicate combination independently of query plans.

SQL Server✓ Tested
PostgresSchema design & transactions

Enforce uniqueness with a dedicated index

Postgres: A unique index rejects a duplicate combination independently of query plans.

Postgres✓ Tested