Ask IT... Thomas Van Parys wrote:
Op 02-07-10 10:47, mavoo schreef:
not quite lieven, too many distincts and too little group by's in your query.
see you all at the bbq
Why are you using such a weird psb email address in your FROM-field? "mavoo@mail.psb.ugent.be" It annoys the mailman mod filter.
T.
On Fri, 02 Jul 2010 10:47:50 +0200, Lieven Sterck <lieven.sterck@psb.vib-ugent.be> wrote:
Eije ...
da haddek ook just doorgestuurd ... stoemen time-clock server thingie !!!>:o
On 02/07/2010 10:45, Sofie Van Landeghem wrote: It's Marijn the 0th to the rescue! :D
Kenny Billiau wrote: If you want the unique rows, use distinct. If you want the highest score per person, you'll have to use group by with an aggregate function ;)
SELECT name, max(score) FROM table GROUP BY name ORDER BY score DESC LIMIT 0,3
Kenny
On Fri, 2 Jul 2010, Lieven Sterck wrote:
SELECT DISTINCT name, score FROM .....
djebus, even I know that !! 8-)
On 02/07/2010 10:23, Frederik Delaere wrote: lets say I have this data
id name score 1 dude1 9.1 2 dude2 9.5 3 dudette1 9.0 4 dude1 9.3 5 dudette1 8.5
And I want to select highest 3 scores:
SELECT score FROM table ORDER BY score DESC LIMIT 0,3
result will be
9.5 9.3 9.1
but how can I select both the name and the score and I only want one score per person
I can do: SELECT DISTINCT name FROM table ORDER BY score DESC LIMIT 0,3 this will give me the correct names in the correct order, but I want their score also
is this possible in one query ?
thanksuwel !