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

Results for “result”

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

689 snippets foundClear filters
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
jQueryEvent control

Attach configuration when registering a handler

jQuery: event.data carries the registration-time data object.

jQuery✓ Tested
SQLConstraints & defaults

Block deletion of a referenced parent

SQL: The default foreign-key action prevents deletion while a child still refers to the parent.

SQL✓ Tested
SQL ServerConstraints & defaults

Block deletion of a referenced parent

SQL Server: The default foreign-key action prevents deletion while a child still refers to the parent.

SQL Server✓ Tested
PostgresConstraints & defaults

Block deletion of a referenced parent

Postgres: The default foreign-key action prevents deletion while a child still refers to the parent.

Postgres✓ Tested
SQLiteConstraints & defaults

Block deletion of a referenced parent

SQLite: The default foreign-key action prevents deletion while a child still refers to the parent.

SQLite✓ Tested
Linux CommandsSearching text

Branch on whether a pattern exists

Linux Commands: Use grep -q in a conditional so an ordinary no-match result is not an unhandled failure.

Linux Commands✓ Tested
SQLiteJSON data

Build a JSON array from rows

Aggregate ordered text values into JSON.

json_group_array✓ Tested
SQLSubqueries & ranked selection

Build a query from several named stages

SQL: Separate row selection from aggregation using two common table expressions.

SQL✓ Tested
SQL ServerSubqueries & ranked selection

Build a query from several named stages

SQL Server: Separate row selection from aggregation using two common table expressions.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Build a query from several named stages

Postgres: Separate row selection from aggregation using two common table expressions.

Postgres✓ Tested