Results for “vs”

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

Bash ScriptsParameter expansion

Distinguish unset variables from empty strings ↗

Bash Scripts: Omitting the colon tests only whether a variable is unset; including it also treats an empty value as missing.

Bash Scripts✓ Tested