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

Results for “between”

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

549 snippets foundClear filters
SQLRelationships & missing data

Pair employees with their managers

SQL: Alias a table twice to represent two different roles in one relationship.

SQL✓ Tested
SQL ServerRelationships & missing data

Pair employees with their managers

SQL Server: Alias a table twice to represent two different roles in one relationship.

SQL Server✓ Tested
PostgresRelationships & missing data

Pair employees with their managers

Postgres: Alias a table twice to represent two different roles in one relationship.

Postgres✓ Tested
SQLiteRelationships & missing data

Pair employees with their managers

SQLite: Alias a table twice to represent two different roles in one relationship.

SQLite✓ Tested
SQLText cleanup & matching

Place missing values after known values portably

SQL: A CASE sort key controls NULL placement without relying on engine-specific defaults.

SQL✓ Tested
SQL ServerText cleanup & matching

Place missing values after known values portably

SQL Server: A CASE sort key controls NULL placement without relying on engine-specific defaults.

SQL Server✓ Tested
PostgresText cleanup & matching

Place missing values after known values portably

Postgres: A CASE sort key controls NULL placement without relying on engine-specific defaults.

Postgres✓ Tested
SQLiteText cleanup & matching

Place missing values after known values portably

SQLite: A CASE sort key controls NULL placement without relying on engine-specific defaults.

SQLite✓ Tested
Arduino / CSensor calculations

Prevent output chatter with separate thresholds

Arduino / C: Use different on and off thresholds to retain state between them.

Arduino / C✓ Tested
SQLWindow analytics

Rank tied scores with competition gaps

SQL: RANK leaves a gap after tied rows, unlike DENSE_RANK.

SQL✓ Tested
SQL ServerWindow analytics

Rank tied scores with competition gaps

SQL Server: RANK leaves a gap after tied rows, unlike DENSE_RANK.

SQL Server✓ Tested
PostgresWindow analytics

Rank tied scores with competition gaps

Postgres: RANK leaves a gap after tied rows, unlike DENSE_RANK.

Postgres✓ Tested