db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Lichtman <swa...@rcn.com>
Subject Re: Fwd: COUNT queries
Date Thu, 10 Nov 2005 03:41:35 GMT

>1) A null column is excluded from a COUNT( colName ) aggregate. This 
>is described in the section 10.9 under General Rules 4a. The 
>database is supposed to raise a warning: "warning--null value 
>eliminated in set function"

If you want to get the count including nulls, you can use COUNT(*), 
which returns the number of rows in the set being aggregated (not the 
number of values).


                        -        Jeff Lichtman
                                 swazoo@rcn.com
                                 Check out Swazoo Koolak's Web Jukebox at
                                 http://swazoo.com/ 


Mime
View raw message