Subject Re: [firebird-support] * vs fieldname
Author Helen Borrie
At 11:38 PM 13/09/2007, you wrote:
>Is there any time where there is an effective difference between:
>
>select count(*) from ...
>
>and
>
>select count(myfieldname) from ...

Sure is. count(*) counts all rows, whereas count(fieldname) counts
all rows that have a non-null value in that field.

./heLen