Re: help please
From: Sripriya <sripriya.s_at_in.bosch.com>
Date: Fri, 31 Jan 2003 09:47:54 +0530
Message-ID: <b1ctdn$ne3$1_at_ns2.fe.internet.bosch.com>
Date: Fri, 31 Jan 2003 09:47:54 +0530
Message-ID: <b1ctdn$ne3$1_at_ns2.fe.internet.bosch.com>
Hello,
While using count in the select statements the null values will not be considered.Because of this, you are not getting the count as 0.
The query must be as follows.
Select count(*) from table_name where field_name <>{condition} or field_name is null.
Regards,
Sripriya
"Oscar" <oscar_at_j.com> wrote in
Received on Fri Jan 31 2003 - 05:17:54 CET