Re: null_count + notnull_count <> total_count ?
From: Joakim Arborelius <joar_at_secrc.abb.se>
Date: 1995/05/29
Message-ID: <3qcc81$cq2_at_sdaw04.seinf.abb.se>#1/1
Received on Mon May 29 1995 - 00:00:00 CEST
Date: 1995/05/29
Message-ID: <3qcc81$cq2_at_sdaw04.seinf.abb.se>#1/1
In article <vkj.252.2FC383A6_at_ctt.bellcore.com>, vkj_at_ctt.bellcore.com says...
>
>Hi,
>
>I am facing a strange problem.
>When I run "select count(*) from table1 where date1 is null", I get 6.
>When I run "select count(*) from table1 where date1 is not null", I get 0.
>But "select count(*) from table1" gives me 6652.
>what is wrong ? date1 field is declared as "date null" in table1.
>
>Vinod
>
I tried the same thing, without any problems(!!!!) so,
null_count + notnull_count <> total_count
Received on Mon May 29 1995 - 00:00:00 CEST