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

Results for “header”

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

515 snippets foundClear filters
SQLiteText cleanup & matching

Remove surrounding spaces from text

SQLite: TRIM removes leading and trailing space characters by default.

SQLite✓ Tested
SQLWindow analytics

Repeat the first ordered value beside each row

SQL: FIRST_VALUE reads the first value in the current window frame.

SQL✓ Tested
SQL ServerWindow analytics

Repeat the first ordered value beside each row

SQL Server: FIRST_VALUE reads the first value in the current window frame.

SQL Server✓ Tested
PostgresWindow analytics

Repeat the first ordered value beside each row

Postgres: FIRST_VALUE reads the first value in the current window frame.

Postgres✓ Tested
SQLiteWindow analytics

Repeat the first ordered value beside each row

SQLite: FIRST_VALUE reads the first value in the current window frame.

SQLite✓ Tested
SQLText cleanup & matching

Replace a literal substring

SQL: REPLACE performs a literal replacement rather than a regular-expression substitution.

SQL✓ Tested
SQL ServerText cleanup & matching

Replace a literal substring

SQL Server: REPLACE performs a literal replacement rather than a regular-expression substitution.

SQL Server✓ Tested
PostgresText cleanup & matching

Replace a literal substring

Postgres: REPLACE performs a literal replacement rather than a regular-expression substitution.

Postgres✓ Tested
SQLiteText cleanup & matching

Replace a literal substring

SQLite: REPLACE performs a literal replacement rather than a regular-expression substitution.

SQLite✓ Tested
PostgresJSON & arrays

Replace a nested JSONB value

Change one path with jsonb_set.

jsonb_set✓ Tested
PostgresWindows & text

Replace all matching text

Normalize repeated whitespace with a regular expression.

regexp_replace✓ Tested
SQLExpressions & aggregates

Replace NULL in a result

Choose a fallback for a missing value.

COALESCE✓ Tested