Very simple SQL question ... or maybe not

Given my_table and data:

col_a col_b col_c

A         7         cat
A         2         dog
B         4         zebra
B         8         buraq

the output should be

A 7 cat
B 8 buraq

in other words... For each unique col_a, select the largest col_b and it's related col_c.

I can do it this like

select col_a, max(col_b||' '||col_c) from my_table group by col_a;

but I suspect there is a more elegant solution.

Thanks,
Mike Received on Tue Apr 03 2001 - 20:08:31 CDT