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

Results for “form”

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

788 snippets foundClear filters
SQLRelationships & missing data

Find parents with at least two child rows

SQL: Use a correlated count when testing a per-parent threshold.

SQL✓ Tested
SQL ServerRelationships & missing data

Find parents with at least two child rows

SQL Server: Use a correlated count when testing a per-parent threshold.

SQL Server✓ Tested
PostgresRelationships & missing data

Find parents with at least two child rows

Postgres: Use a correlated count when testing a per-parent threshold.

Postgres✓ Tested
SQLiteRelationships & missing data

Find parents with at least two child rows

SQLite: Use a correlated count when testing a per-parent threshold.

SQLite✓ Tested
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