</>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
GitWorking tree & staging

See changed files

Show a concise working-tree status.

status✓ Tested
SQLSelect & filter

Select an inclusive range

Find rows with values between two endpoints.

BETWEEN✓ Tested
SQL ServerSelect & page

Select the highest values with TOP

Limit an ordered SQL Server result.

TOP✓ Tested
SQLWindow analytics

Select the top row in each group with a tie-breaker

SQL: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.

SQL✓ Tested
SQL ServerWindow analytics

Select the top row in each group with a tie-breaker

SQL Server: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.

SQL Server✓ Tested
PostgresWindow analytics

Select the top row in each group with a tie-breaker

Postgres: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.

Postgres✓ Tested
SQLiteWindow analytics

Select the top row in each group with a tie-breaker

SQLite: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.

SQLite✓ Tested
SQLGetting Started

Select values in an inclusive range

SQL: BETWEEN includes both endpoints of the range.

SQL✓ Tested
SQL ServerGetting Started

Select values in an inclusive range

SQL Server: BETWEEN includes both endpoints of the range.

SQL Server✓ Tested
PostgresGetting Started

Select values in an inclusive range

Postgres: BETWEEN includes both endpoints of the range.

Postgres✓ Tested
SQLiteGetting Started

Select values in an inclusive range

SQLite: BETWEEN includes both endpoints of the range.

SQLite✓ Tested
SQL ServerJSON & results

Serialize query rows as JSON

Return a JSON array directly from a SELECT.

FOR JSON✓ Tested