Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |