Re: Laugh or Cry (part 2)

From: Walter Mitty <>
Date: Wed, 22 Jul 2009 18:08:48 GMT
Message-ID: <QAI9m.789$>

"Cimode" <> wrote in message
>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

Original text of this message