Re: count(*) with NULLs involved
From: Gary Assa <gsa_at_li.net>
Date: 1996/11/04
Message-ID: <55ktqn$3qf_at_linet01.li.net>#1/1
Date: 1996/11/04
Message-ID: <55ktqn$3qf_at_linet01.li.net>#1/1
Even simpler:
select count(*) from test_table
where nvl(column_X,'Z') not in ('B','C');
-- ========================================================= http://www.li.net/~gsa/index.html This is my signature file, not part of this mail message.Received on Mon Nov 04 1996 - 00:00:00 CET