Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Very simple SQL question ... or maybe not

Very simple SQL question ... or maybe not

From: Mike Moore <hicamel_at_mail.home.com>
Date: Wed, 04 Apr 2001 01:08:31 GMT
Message-ID: <juuy6.91$4L4.60787@news1.frmt1.sfba.home.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US