Bob Murdoch wrote:

>select
> count(*)
>from
> test_group_by
>
>
>However, if I change the query to
>
>select
> column1, count(*)
>from
> test_group_by
>group by
> column1
>
>I recieve an empty result set. I think I would have expected a single row,
>with column1=NULL and a count of 0.
>

In the second case, firebird found no groups, which is like select *
from an empty table. If there were a way to count the groups, you'd get
the count of 0.

Regards,


Ann