Very Computer

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.

SELECT b.c1, b.c2, a.c3
    FROM
        table a,
        (
            SELECT
                c1 = MAX(c1), c.2
                FROM table
                GROUP BY c2
        ) b
        WHERE a.c2 = b.c2

Quote:> 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.

Quote:>                 c1 = MAX(c1), c.2