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 -> Re: SELECT in a [select_list]

Re: SELECT in a [select_list]

From: Bernhard Seeling <seeling_at_kzvth.ef.uunet.de>
Date: Mon, 26 Jul 1999 14:55:06 +0200
Message-ID: <7nhm1g$eef$1@newsread.do.de.uu.net>

Bernhard Seeling schrieb in Nachricht
<7nhhbv$b3n$1_at_newsread.do.de.uu.net>...
>select a,maxb.b
>from d ,(select max(b) b from c) maxb
>group by maxb.b ;
>
>MfG Bernhard
>

  sorry

select

                 max(a) a,maxb.b
from
                d ,(select max(b) b from c) maxb
group by
                 maxb.b ;
--------------------------------------------------------------
select
                 a,maxb.b
from
                d ,(select max(b) b from c) maxb;





Received on Mon Jul 26 1999 - 07:55:06 CDT

Original text of this message

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