null_count + notnull_count <> total_count ?
From: vkj <vkj_at_ctt.bellcore.com>
Date: 1995/05/24
Message-ID: <vkj.252.2FC383A6_at_ctt.bellcore.com>#1/1
Date: 1995/05/24
Message-ID: <vkj.252.2FC383A6_at_ctt.bellcore.com>#1/1
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 Received on Wed May 24 1995 - 00:00:00 CEST