Re: count(*) with NULLs involved

Two simple solutions work for me:

select count(*) from test_table
 where column_X not in ('B','C')

    or column_X is null;

  select column_X, count(*)
    from test_table
group by column_X;

Ron Received on Fri Nov 01 1996 - 00:00:00 CET