again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 8:44 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: sum() using group, and duplicates problems...
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Thanks again Serge and Don,
>
&
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Thanks again Serge and Don,
>
> Don not to sound like an idiot but what would
> you recommend on adding a unique key. I understand
> the idea, but didn't want to corrupt tables trying to
> get it right.
>
> Serge, I knew DISTINCT operated on whole l
, March 26, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: Re: sum() using group, and duplicates problems...
The DISTINCT is almost usless when done on a GROUP BY clause. Also DISTINCT
operates on the entire row and not just on the field.
ie It will give you DISTINCT measurement, sum(val), pcfver, hou
The DISTINCT is almost usless when done on a GROUP BY clause. Also DISTINCT operates
on the entire row and not just on the field.
ie It will give you DISTINCT measurement, sum(val), pcfver, hour, release. And not
just DISTINCT measurement results.
Serge.
On Wed, 26 Mar 2003 12:00:24 -0600 (
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Don
>
> Thanks. I will have to change them and try that.
>
> I had been bouncing back and forth between decimal and
> numeric but wasn't sure which was working better.
>
> I still think it might have to do with my sql query.
>
> Here's an example as
.
Thanks for your help.
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 8:30 PM
To: Black, Kelly W [PCS]
Cc: Mysql (E-mail)
Subject: RE: sum() usi
On 25-Mar-2003 Black, Kelly W [PCS] wrote:
>
> On 25-Mar-2003 Black, Kelly W [PCS] wrote:
>>> Hello.
>>>
>>> Sorry for the long post. This has been a big problem for me, and I
>>> hope someone will help...
>>>
>>> I have a long standing problem with an MySQL query.
>>> Or perhaps a couple of
On 25-Mar-2003 Black, Kelly W [PCS] wrote:
> Hello.
>
> Sorry for the long post. This has been a big problem for me, and I
> hope someone will help...
>
> I have a long standing problem with an MySQL query.
> Or perhaps a couple of sql query problems...
>
> Firstly I have been told I cannot u
Hello.
Sorry for the long post. This has been a big problem for me, and I
hope someone will help...
I have a long standing problem with an MySQL query.
Or perhaps a couple of sql query problems...
Firstly I have been told I cannot use sum() on a value while using
group by "parm" because it's n
