Results for “display”

SQL ServerReporting & grouped calculations

Count distinct values within a result ↗

SQL Server: COUNT DISTINCT counts distinct non-null values.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Count distinct values within a result ↗

Postgres: COUNT DISTINCT counts distinct non-null values.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Count distinct values within a result ↗

SQLite: COUNT DISTINCT counts distinct non-null values.

SQLite✓ Tested

PowerShellCollections & objects

Count items by group ↗

Group repeated values and report each count.

Group-Object✓ 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