Re: count(*) with NULLs involved
From: Jason Grace <jgrace_at_saltmine.radix.net>
Date: 1996/11/04
Message-ID: <Pine.SOL.3.91.961104160903.19053A-100000_at_saltmine.radix.net>#1/1
Date: 1996/11/04
Message-ID: <Pine.SOL.3.91.961104160903.19053A-100000_at_saltmine.radix.net>#1/1
On Fri, 1 Nov 1996, Krishna K. Kurup wrote:
> The query would look like:
>
> select count(*) from test_table
> where column_X||'XXXX' not in ('BXXXX','CXXXX');
>
How about
select count(*) from test_table
where (column_X is null or column_X not in ('B','C'));
Received on Mon Nov 04 1996 - 00:00:00 CET