Ann W. Harrison wrote:

>At 12:31 AM 2/4/2004, James wrote:
>
>
>
>>what is the difference between
>>
>>select "counterno", sum(1)
>> from "counter"
>> group by "counterno"
>> having sum(1) > 1
>>
>>and
>>
>>select "counterno", count("counterno")
>> from "counter"
>> group by "counterno"
>> having count("counterno") > 1
>>
>>
>
>Essentially the "sum (1)" is equivalent
>to count(*). Count(<field>) is slightly
>different as it does not count rows with
>a null value of <field>. In this case,
>that matters not at all. To the best of
>my understanding these queries are equivalent.
>
>And do yourself a favor, lose the quotes.
>
>
>

Thank Ann, David. :-)

Cheers

James