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

Results for “Schema design & transactions”

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

377 snippets foundClear filters
SQL ServerSubqueries & ranked selection

Sort preferred rows ahead of other rows

SQL Server: A CASE ordering key expresses business priority before a stable secondary sort.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Sort preferred rows ahead of other rows

Postgres: A CASE ordering key expresses business priority before a stable secondary sort.

Postgres✓ Tested
SQLiteSubqueries & ranked selection

Sort preferred rows ahead of other rows

SQLite: A CASE ordering key expresses business priority before a stable secondary sort.

SQLite✓ Tested
PostgresGetting Started

Sort the highest quantities first

Postgres: Specify descending order and a stable tie breaker.

Postgres✓ Tested
CSSResponsive design

Stack columns on small screens

Change a two-column CSS grid to one column at a viewport breakpoint.

CSS✓ Tested
SQLWindow analytics

Sum a row and its immediate predecessor

SQL: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

SQL✓ Tested
SQL ServerWindow analytics

Sum a row and its immediate predecessor

SQL Server: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

SQL Server✓ Tested
PostgresWindow analytics

Sum a row and its immediate predecessor

Postgres: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

Postgres✓ Tested
SQLiteWindow analytics

Sum a row and its immediate predecessor

SQLite: A ROWS frame counts physical ordered rows rather than all peers with the same sort value.

SQLite✓ Tested
SQLText cleanup & matching

Treat an empty trimmed value as missing

SQL: NULLIF converts an empty string to NULL before a fallback is applied.

SQL✓ Tested
SQL ServerText cleanup & matching

Treat an empty trimmed value as missing

SQL Server: NULLIF converts an empty string to NULL before a fallback is applied.

SQL Server✓ Tested
PostgresText cleanup & matching

Treat an empty trimmed value as missing

Postgres: NULLIF converts an empty string to NULL before a fallback is applied.

Postgres✓ Tested