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

Results for “IS NULL”

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

1898 snippets foundClear filters
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
SQLGetting Started

Find missing values with IS NULL

SQL: Use IS NULL rather than equality to test for missing data.

SQL✓ Tested
SQL ServerGetting Started

Find missing values with IS NULL

SQL Server: Use IS NULL rather than equality to test for missing data.

SQL Server✓ Tested
PostgresGetting Started

Find missing values with IS NULL

Postgres: Use IS NULL rather than equality to test for missing data.

Postgres✓ Tested
SQLiteGetting Started

Find missing values with IS NULL

SQLite: Use IS NULL rather than equality to test for missing data.

SQLite✓ Tested
SQLChange & combine data

Test missing values with IS NULL

Find rows where an optional value is absent.

IS NULL✓ Tested
SQLSubqueries & ranked selection

Include missing values in a not-equal filter

SQL: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.

SQL✓ Tested
SQL ServerSubqueries & ranked selection

Include missing values in a not-equal filter

SQL Server: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Include missing values in a not-equal filter

Postgres: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.

Postgres✓ Tested