Subject Re: [firebird-support] * vs fieldname
Author Magnus Titho
Nick Upson wrote:
> Is there any time where there is an effective difference between:
> select count(*) from ...
> and
> select count(myfieldname) from ...
Yes, count(myfieldname) doesn't count the record if the value for the
selected field is null, count(*) counts all records regardless of their