Re: Laugh or Cry (part 2)
From: Walter Mitty <wamitty_at_verizon.net>
Date: Wed, 22 Jul 2009 18:08:48 GMT
Message-ID: <QAI9m.789$MA3.6_at_nwrddc02.gnilink.net>
Date: Wed, 22 Jul 2009 18:08:48 GMT
Message-ID: <QAI9m.789$MA3.6_at_nwrddc02.gnilink.net>
"Cimode" <cimode_at_hotmail.com> wrote in message
news:5b7fe013-1662-4259-8930-0115a8f45a87_at_32g2000yqj.googlegroups.com...
>A quote from Experts Exchange...I let you judge for yourself...
>
> <<
> Just to clarify, the fact that I have duplicates isn't a problem --
> the problem arises when I'm trying to SUM the value of one of the
> fields in tblSuite. I just need to know how to ignore those
> duplicates, not to get rid of them.
>>>
I would be tempted to offer something like the following in ExpertsExchange:
select sum (TheColumn) as Total
from (select distinct * from TheTable);
But I would be afraid that somebody would not realize that I'm just goofing. Received on Wed Jul 22 2009 - 20:08:48 CEST