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.