(or so I thought)
Can anybody help me out with this??? This would make life so much easier
for my poor stats package. Anyone?
-Original Message-
From: Solsberry, Glendon
Sent: Friday, September 14, 2001 10:17 AM
To: MySQL
Subject: Simple SELECT query (or so I thought)
I am
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
not satisfy your wish to have the list sorted with the highest
wucount/rank first... right?
-Original Message-
From: Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:29 AM
To: '[EMAIL PROTECTED]'
Subject: Simple SELECT query (or so I thought)
Can anybody
, but the data still sorted on wucount.
Ideas?
Glen
-Original Message-
From: Terje Kristensen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:39 AM
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: SV: Simple SELECT query (or so I thought)
If you change you order
; [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: Solsberry, Glendon; [EMAIL
-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:
What
the 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
I am running a stats page for our Genome@Home team, and I'm trying to get a
simple SELECT that will get the data that I need...
Ok, I have a table setup like this:
Genomestats
---
usernamevarchar(255)
curDate datetime
wucount
I am running a stats page for our Genome@Home team, and I'm trying to get a
simple SELECT that will get the data that I need...
Ok, I have a table setup like this:
Genomestats
---
usernamevarchar(255)
curDate datetime
wucount