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

Results for “INSERT”

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

381 snippets foundClear filters
SQLRelationships & missing data

Find records without any related rows

SQL: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL✓ Tested
SQL ServerRelationships & missing data

Find records without any related rows

SQL Server: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQL Server✓ Tested
PostgresRelationships & missing data

Find records without any related rows

Postgres: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

Postgres✓ Tested
SQLiteRelationships & missing data

Find records without any related rows

SQLite: NOT EXISTS avoids the NULL pitfalls of NOT IN when the subquery column can be missing.

SQLite✓ Tested
SQLBulk changes & set operations

Find rows in the first result but not the second

SQL: EXCEPT calculates a distinct result-set difference.

SQL✓ Tested
SQL ServerBulk changes & set operations

Find rows in the first result but not the second

SQL Server: EXCEPT calculates a distinct result-set difference.

SQL Server✓ Tested
PostgresBulk changes & set operations

Find rows in the first result but not the second

Postgres: EXCEPT calculates a distinct result-set difference.

Postgres✓ Tested
SQLiteBulk changes & set operations

Find rows in the first result but not the second

SQLite: EXCEPT calculates a distinct result-set difference.

SQLite✓ Tested
SQLBulk changes & set operations

Find rows shared by two query results

SQL: INTERSECT compares complete selected rows and removes duplicates.

SQL✓ Tested
SQL ServerBulk changes & set operations

Find rows shared by two query results

SQL Server: INTERSECT compares complete selected rows and removes duplicates.

SQL Server✓ Tested
PostgresBulk changes & set operations

Find rows shared by two query results

Postgres: INTERSECT compares complete selected rows and removes duplicates.

Postgres✓ Tested
SQLiteBulk changes & set operations

Find rows shared by two query results

SQLite: INTERSECT compares complete selected rows and removes duplicates.

SQLite✓ Tested