Re: SELECT in a [select

From: Bernhard Seeling <seeling_at_kzvth.ef.uunet.de>
Date: Mon, 26 Jul 1999 13:36:43 +0200
Message-ID: <7nhhbv$b3n$1@newsread.do.de.uu.net>

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

MfG Bernhard

abeba_at_my-deja.com schrieb in Nachricht <7nhf0g$7mf$1_at_nnrp1.deja.com>...
>
>
>Using Oracle8, I want to submit this query :
>
>SELECT a , (SELECT MAX(b) FROM c)
>FROM d
>
>but I keep having the same message : (ORA-00936 missing expression)
>
>Is it possible to have a query in a [SELECT_LIST]
>or are there any other ways to do the same thing ????
>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jul 26 1999 - 06:36:43 CDT

Re: SELECT in a [select_list]