|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 5th, 2004, 07:54 AM
|
|||
|
|||
|
score table
I have a table named scores containing names points and dates like this
Name Points Date Jim 10 1-8 Remco 9 1-8 Jim 11 2-8 etc. I want to list every name once with the best score (highest number of points) ordered by score (the highest score first) Any help would be very appreciated Greetings Remco
|
|
#2
August 5th, 2004, 08:08 AM
|
|||
|
|||
|
Oops..... forgot the query
The query I have so far is: Code:
select name, max(points) from scores group by name but it does not sort, I tried order by but I get errors on that
|
|
| Viewing: ASP Free Forums > Database > SQL Development > score table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
