I have been duly chastened ...

For a technical explanation of why "count" does what it does behind the scenes, see Ann Harrisons post from this weekend re MS SQL versus Firebird.

I have other tasks on my backlog or I would add this to my benchmark testing because it has potential to give details about the behavior of the generic "a" DBMS's innards, with some other detective work.

----- Original Message -----
From: James
To: firebird-support@yahoogroups.com
Sent: Tuesday, February 03, 2004 9:31 PM
Subject: [firebird-support] sum vs count


Hi

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

I have some on some post here in this forum, that says using the count
will not give you the desired result.

What Iam trying to do here is to find for duplicate record thru counterno.

Any comments is greatly appreciated.

James



------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]