Selecting particular row

[LordofShadowz]

SELECT * FROM summary_table ORDER BY skill DESC;

How could I select a single row from that search by number
(ie row 1 should have the highest skill number the last row should have the lowest skill number)

 

[KarveR]

unfortuately you need to specify every field you want in the result, or you can do the query in 2 parts.

1) specify everything:

select @top:=max(skill),other_field,other_filed2 from something where skill=@top order by skill;

2) do 2 bits:

select @top:=max(skill) from yourtable;
select * from your_table where skill=@top;

user variables remain for the session, - haven't figured out quite what that means but hey, I didnt write it ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[danielhozac]

Somewhat simpler version:
[tt]SELECT * FROM summary_table ORDER BY skill DESC LIMIT 1[/tt] //Daniel

 

[KarveR]

yeah, that as well Dan

Sometimes simple evades me.. or is it me being simple that causes the problem ... ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.