Subject | Re: [firebird-support] * vs fieldname |
---|---|
Author | Helen Borrie |
Post date | 2007-09-13T13:50:11Z |
At 11:38 PM 13/09/2007, you wrote:
all rows that have a non-null value in that field.
./heLen
>Is there any time where there is an effective difference between:Sure is. count(*) counts all rows, whereas count(fieldname) counts
>
>select count(*) from ...
>
>and
>
>select count(myfieldname) from ...
all rows that have a non-null value in that field.
./heLen