I'm somewhat new to SQL, and here's my problem. I have a table with

three columns, one of which I want to find the max of and the second

of which I want to group by. So, I'm doing something like this:

select max(c1), c2, c3

from tbl

group by c2, c3

Problem with this is that I don't really want to group by the third

column. I want to group by the second and "find out" what the third

happens to be (i.e., what the data field of c3 is in the row where c1

is max, "grouped by" c2). Sorry if this is somewhat unclear. Can

anyone help me? Thanks.