> > On MS SQL Server 2000, one can pass a field name to the COUNT function,
and
> > though I haven't yet seen any difference in the results between the two,
the
> > queries run faster with COUNT() than with COUNT(*).
>
> COUNT(fieldname) provides the count of rows where the data in 'fieldname'
is
I have the following table/data
ClientIPClientDomain
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
211.141.67.7xmailserver.org
211.141.67.7xmailserver.org
2 matches
Mail list logo