Results for “generated column”

SQLiteReporting & grouped calculations

Count distinct values within a result ↗

SQLite: COUNT DISTINCT counts distinct non-null values.

SQLite✓ Tested

SQLExpressions & aggregates

Count rows per category ↗

Aggregate rows sharing the same category.

GROUP BY✓ Tested

SQLReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQL: SUM over CASE expressions calculates several conditional counts in one scan.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQL Server: SUM over CASE expressions calculates several conditional counts in one scan.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Count rows satisfying separate conditions ↗

Postgres: SUM over CASE expressions calculates several conditional counts in one scan.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Count rows satisfying separate conditions ↗

SQLite: SUM over CASE expressions calculates several conditional counts in one scan.

SQLite✓ Tested

SQLGetting Started

Count the rows in a table ↗

SQL: COUNT(*) includes every row, including rows with NULL columns.

SQL✓ Tested

SQL ServerGetting Started

Count the rows in a table ↗

SQL Server: COUNT(*) includes every row, including rows with NULL columns.

SQL Server✓ Tested

PostgresGetting Started

Count the rows in a table ↗

Postgres: COUNT(*) includes every row, including rows with NULL columns.

Postgres✓ Tested

SQLiteGetting Started

Count the rows in a table ↗

SQLite: COUNT(*) includes every row, including rows with NULL columns.

SQLite✓ Tested

Linux CommandsStreams & byte tools

Count whitespace-separated words ↗

Linux Commands: Use wc -w with standard input to omit the filename column.

Linux Commands✓ Tested

SQLiteTables & writes

Create a STRICT table ↗

Require values compatible with declared column types.

STRICT✓ Tested