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

Results for “state”

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

453 snippets foundClear filters
SQLChange & combine data

Delete one matching row

Remove a selected record and inspect what remains.

DELETE✓ Tested
SQLBulk changes & set operations

Delete rows selected by a related table

SQL: A correlated EXISTS limits the delete to explicitly listed records.

SQL✓ Tested
SQL ServerBulk changes & set operations

Delete rows selected by a related table

SQL Server: A correlated EXISTS limits the delete to explicitly listed records.

SQL Server✓ Tested
PostgresBulk changes & set operations

Delete rows selected by a related table

Postgres: A correlated EXISTS limits the delete to explicitly listed records.

Postgres✓ Tested
SQLiteBulk changes & set operations

Delete rows selected by a related table

SQLite: A correlated EXISTS limits the delete to explicitly listed records.

SQLite✓ Tested
C++Tasks & synchronization

Deliver a result through a promise and future

C++: A promise sets a shared state and its future retrieves the value.

C++✓ Tested
SQLReporting & grouped calculations

Distinguish row count from non-null value count

SQL: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL✓ Tested
SQL ServerReporting & grouped calculations

Distinguish row count from non-null value count

SQL Server: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL Server✓ Tested
PostgresReporting & grouped calculations

Distinguish row count from non-null value count

Postgres: COUNT(*) includes every row while COUNT(column) skips NULL values.

Postgres✓ Tested
SQLiteReporting & grouped calculations

Distinguish row count from non-null value count

SQLite: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQLite✓ Tested
SQLWindow analytics

Divide an ordered result into numbered buckets

SQL: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQL✓ Tested
SQL ServerWindow analytics

Divide an ordered result into numbered buckets

SQL Server: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQL Server✓ Tested