db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: getting a subset from a database of records
Date Thu, 31 Dec 2015 02:24:24 GMT
On 12/30/15 5:29 PM, Bob M wrote:
> Hi
>
> My database records contain a field A which either has a numeric entry or is
> <NULL>
>
> I wish to pull out a subset where the value of various fields are set by me.
> That part is working OK.
>
> But, in addition, I only want those records where the above field A is not
> <NULL>  to be counted
>
> What do I incorporate into the request to get that?
>
> Bob M
>
>
>
> --
> View this message in context: http://apache-database.10148.n7.nabble.com/getting-a-subset-from-a-database-of-records-tp145247.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
Hi Bob,

Have you tried adding the following phrase to your query:

   WHERE a IS NOT NULL

Hope this helps,
-Rick

Mime
View raw message