|List:||General Discussion||« Previous MessageNext Message »|
|From:||chester||Date:||August 25 2000 6:44pm|
|View as plain text|
I have a table with two columns. | username | score | I wish to select the top five scores for distinct users using only one query. When I do a GROUP BY command it selects their first score, I want it to sort the scores, and then select distinct users so that I get a list of five unique users and their highest score. Any way to do that using one query?
|• Group By||chester||25 Aug|
|• RE: Group By||Jeff Brewer||25 Aug|