Re: Laugh or Cry (part 2)
Date: Wed, 22 Jul 2009 18:08:48 GMT
"Cimode" <cimode_at_hotmail.com> 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