SQL COUNT statement (other than COUNT(*))

Jun 27, 2022 | | 1 min | #db

The most common case is not that interesting - select count(*) from ... simply returns the number of rows, including null values. d

select count(columnName) is similar, but it does not count null values in columnName.

select count(distinct columnName) counts distinct values, excluding null values.