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

Results for “SQL”

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

500 snippets foundClear filters
SQLiteRelationships & missing data

Keep parent rows while filtering joined children

SQLite: Put a child filter in ON when unmatched parents must remain in the result.

SQLite✓ Tested
SQLGetting Started

Keep rows matching a condition

SQL: Use WHERE to select rows with a particular category.

SQL✓ Tested
SQL ServerGetting Started

Keep rows matching a condition

SQL Server: Use WHERE to select rows with a particular category.

SQL Server✓ Tested
SQLiteGetting Started

Keep rows matching a condition

SQLite: Use WHERE to select rows with a particular category.

SQLite✓ Tested
SQLRelationships & missing data

List unordered pairs without duplicate reversals

SQL: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

SQL✓ Tested
SQL ServerRelationships & missing data

List unordered pairs without duplicate reversals

SQL Server: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

SQL Server✓ Tested
SQLiteRelationships & missing data

List unordered pairs without duplicate reversals

SQLite: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

SQLite✓ Tested
SQLConstraints & defaults

Make a pair of columns unique together

SQL: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQL✓ Tested
SQL ServerConstraints & defaults

Make a pair of columns unique together

SQL Server: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQL Server✓ Tested
SQLiteConstraints & defaults

Make a pair of columns unique together

SQLite: A composite primary key permits repeated individual values while forbidding a duplicate combination.

SQLite✓ Tested
SQLText cleanup & matching

Match a known text prefix

SQL: A percent wildcard matches zero or more characters following the prefix.

SQL✓ Tested
SQL ServerText cleanup & matching

Match a known text prefix

SQL Server: A percent wildcard matches zero or more characters following the prefix.

SQL Server✓ Tested