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
ColA | theCount NULL | 0
Why is this happening, and what can I do to avoid this?