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