hi all,

I have a table below...

c1 c2 c3
1 1 a
1 2 b
2 1 c
2 2 d
3 1 e
3 2 f


I want to get (1,2,b), (2,2,d), (3,2,f), i.e. group by c1, which having
the largest c2, and select the row

but the following quesy can't work...

SELECT *
FROM `table_1`
GROUP BY c1
ORDER BY c2

how to do this? thanks.