A SELECT statement returns several rows:
SELECT
ColA
FROM
TableA
WHERE
ColA IS NULL
I get 47 rows that have 'NULL' for ColA within TableA.
ColA
NULL
NULL
NULL
etc...
If I add an aggregate to this query:
SELECT
ColA,
COUNT(ColA) AS theCount
FROM
TableA
WHERE
ColA IS NULL
GROUP BY ColA
I get
ColA | theCount
NULL | 0
Why is this happening, and what can I do to avoid this?