ramifications
of this and decide if.
Like I said, give it a try... what have you got to lose?
-Original Message-
From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 11:35 AM
To: [EMAIL PROTECTED]
Subject: RE: Simple SELECT query (or so I thought)
Correct. I
lem?
Glen
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:59 AM
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: RE: Simple SELECT query (or so I thought)
I am not possitive that I completely follow what you are trying to do...
but, here goes
endon; [EMAIL PROTECTED]
Subject: RE: Simple SELECT query (or so I thought)
Three things to try
One use "distinct"
Two use temp table
Three use oracle and unions
Simon
-Original Message-
From: Terje Kristensen [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2001 14:39
To: Sol
Well, here is where the problem comes in... Taking the data that I posted:
junior || 2001-09-14 06:30:00 || 51819 || 3019 || 156 || 11 || 983928120
junior || 2001-09-14 03:30:00 || 51743 || 3014 || 155 || 11 || 983928120
junior || 2001-09-13 06:30:00 || 51480 || 2997 || 149 || 11 || 983928120
Ir
I am not possitive that I completely follow what you are trying to do...
but, here goes:
What if you create a temporary table first:
CREATE TEMPORARY TABLE tu (
usernamevarchar(255),
maxwucount bigint,
maxrank int
) SELECT username, max(wucount) as maxwu
Three things to try
One use "distinct"
Two use temp table
Three use oracle and unions
Simon
-Original Message-
From: Terje Kristensen [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2001 14:39
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: SV: Simple SELECT query (or so I thought)
Hi,
How about adding and ORDER BY username, giving:
SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate',
'$lastDay') order by username, wucount desc, rank desc;
Andrew Murphy
<^oo^> Im a bit of a night owl.
-Original Message-
From: Solsberry, Glendon [mailto:[EMAIL P