using max & min together

[rk68]

The data in table is as follows:
Stage MemberID TimeTaken Score
1 11 26 101
2 11 24 105
1 12 35 120
2 12 44 115
1 13 17 105
2 13 15 107

Output required
2 11 24 105
1 12 35 120
2 13 15 107
How do i use min() & max() in my query to get memberId with less time taken & max score in which stage.

TIA
RAJ

 

[rk68]

got the solution
select a.mbr, min(a.timet) as mint, max(a.score) as mxscr from test a
where a.score in(select max(t.score) from test t where t.mbr=a.mbr)
group by a.mbr