How do I count a column that is NULL without CASE. I was looking at NULLIF
and ISNULL, they can't seem to do the job.

Thanks

Sorry about double posting, I replied to my question by mistake.

I tried
CASE EventID when NULL then 1 else 0 end

It always return 0, why ?


"Phil Hunt" <aaa (AT) aaa (DOT) com> wrote

Phil Hunt wrote:
comparison to be performed, the result of which will always be false. You
have to structure it like:

CASE when EventID IS NULL then 1 else 0 end

To answer your original question, you can subtract the result of
count(distinct column_name) from count(*):

select count(*) - count(distinct eventid) as null_eventids

That's it.Thanks.


"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> wrote

SELECT COUNT(*)- COUNT(event_id) AS null_even_cnt
FROM Events;

Bob Barrows wrote:
Oh dear. Why did I put that "distinct" in there? I have no idea what I was
thinking when I typed that. The correct statement is as CELKO wrote:
select count(*) - count(eventid) as null_eventids