Re: Help needed: Oracle ans SQL

Alexei VORONOV wrote:
>
> select A.KEY, A.VALUE, A.LEV from <Your Table> A, (select KEY, max(LEV) F
> from <Your table> group by KEY) B
> where A.KEY=B.KEY and A.LEV=B.F;
>

 Thx a lot! Really funny: I posted my question in an other forum and there the answer came about 30secs after yours!

Again, thx a lot!

Mirko Received on Tue Oct 16 2001 - 08:19:34 CDT