Re: SQL Plus Help

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Thu, 18 Mar 2004 16:55:23 GMT
Message-ID: <%vk6c.101405$Up2.52757@pd7tw1no>

kodo wrote:
> ashok_settyvari_at_yahoo.com (Ash) writes:
>
>

>>select ALAN8,MAX(ALEFTB),ALADD1,ALADD2,ALADD3,ALADD4,ALCTY1,ALADDS,ALADDZ
>>from F0116,F0101 where ABAN8=ALAN8 AND abat1='C' and ALAN8=55;
>>
>>When I executed the above code, Im getting error not a single-group
>>group function.

>
>
> This is NOT a SQL Plus problem.
>

It's also basic SQL. You are missing a group by clause, eg.

select ALAN8,MAX(ALEFTB),ALADD1,ALADD2,ALADD3,ALADD4,ALCTY1,ALADDS,ALADDZ from F0116,F0101
where ABAN8=ALAN8 AND abat1='C' and ALAN8=55 group by ALAN8,ALADD1,ALADD2,ALADD3,ALADD4,ALCTY1,ALADDS,ALADDZ;

tahiti.oracle.com is where to look for this. Received on Thu Mar 18 2004 - 10:55:23 CST