SQL COUNT statement (other than COUNT(*))

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.

---

To contact me, send an email anytime or leave a comment below.