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

Home -> Community -> Usenet -> c.d.o.misc -> Re: group by problem (ora-00979)

Re: group by problem (ora-00979)

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 16 Jul 2002 14:57:15 GMT
Message-ID: <fvWY8.1057$_51.973@rwcrnsc52.ops.asp.att.net>


 What version of Oracle?
Jim
"Shoval Tomer" <shoval_at_softov.co.il> wrote in message news:714a60c1.0207160409.4a3662b4_at_posting.google.com...
> trying to group by when the sub query has count(*) in it.
> This query works fine in SQL server, though.
>
> select s.sndnam as Sender, s.sndcode as SenderCode,
> (select count(*) from r rRes,o oRes,c cRes
> where rRes.rordno = oRes.oordno
> and rRes.rdate = oRes.odate and oRes.osndcod = s.sndcode
> and cRes.ccode = rRes.rtest and rRes.rresult='POSITIVE') as TotalPos
> from s , o , r , c
> where s.sndcode = o.osndcod and r.rordno = o.oordno and r.rdate =
o.odate
> and c.ccode = r.rtest
> group by s.sndnam, s.sndcode
>
>
>
> Thanks
Received on Tue Jul 16 2002 - 09:57:15 CDT

Original text of this message

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