Thomas Abeel wrote:
Ask IT...
IT told him to wait with the ubuntu 10.04 update .. :) its the root of all his troubles !
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 !
_______________________________________________ Binari Implicitly Neglects All Recursive Iterations https://maillist.psb.ugent.be/mailman/listinfo/binari
-- ================================================================== Frederik Delaere Tel:+32 (0)9 331 38 14 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM frlae@psb.vib-ugent.be http://www.psb.vib-ugent.be ==================================================================