mysql - SELECT MAX() and corresponding field in the same row -

here's table a

orderid groupid   nameid 1       grade   foo 2       grade   bar 3       grade   rain 1       grade b   rain 2       grade b   foo 3       grade b   bar 1       grade c   rain 2       grade c   bar 3       grade c   foo 

desired result:

rain bar foo 

i need nameid of max(orderid) each grade. can right orderid each grade, nameid stays first.

thanks lot!

---

praveen gave right query! question under answer

edit: fixed mistake in answer.

you looking quite like:

select   orderid,   groupid,   nameid     concat(orderid,'-',groupid) in (select concat(max(orderid),'-',groupid) group groupid) 

edit: in regards question:
put list in order of nameid, add query:

order   nameid