Subject Re: [firebird-support] * vs fieldname
Author Thomas Steinmaurer
> Is there any time where there is an effective difference between:
> select count(*) from ...
> and
> select count(myfieldname) from ...

Possibly not, but be aware that count doesn't count NULL states, so the
result might differ when you are using a NULLable field.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions