Re: [sqlite] Question about expected query result??

2004-05-14 Thread Brass Tilde
> > 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

[sqlite] Question about expected query result??

2004-05-13 Thread Shawn Anderson
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