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

Results for “columns”

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

512 snippets foundClear filters
PostgresGetting Started

Sort the highest quantities first

Postgres: Specify descending order and a stable tie breaker.

Postgres✓ Tested
SQLiteGetting Started

Sort the highest quantities first

SQLite: Specify descending order and a stable tie breaker.

SQLite✓ Tested
SQL ServerDates & text

Split delimited text with positions

Retain original order with STRING_SPLIT ordinals.

STRING_SPLIT✓ Tested
SQL ServerSelect & page

Substitute a value for NULL

Use SQL Server’s ISNULL expression.

ISNULL✓ 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
SQLExpressions & aggregates

Sum values per category

Calculate a grouped total.

SUM✓ Tested
SQLChange & combine data

Test missing values with IS NULL

Find rows where an optional value is absent.

IS NULL✓ 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