Viewing 5 posts - 1 through 5 (of 5 total)
Try this
select id,pmt2.account,pmt2.date
from PaymentTable pmt2,
( select distinct account,max(Date) date
from PaymentTable
group by (account))pmt1
where pmt2.account=pmt1.account
and pmt2.date=pmt1.date
Have a great day
October 12, 2004 at 11:02 pm
#526453
select
distinct TABLE1.ID ID,TABLE1.FIRESTNAME FIRSTNAME,LASTNAME,
August 11, 2004 at 11:51 pm
#518586
select (Todate-FromDate) "NoOfdays" from dual.
August 9, 2004 at 12:06 am
#518127
select tempemp.rank,tempemp.empno,ename,age
from emp,(select rank=count(*),empno=A.empno
from (select empno from emp)A,
(select empno from emp)B
where A.empno>=B.empno
group by A.empno)tempemp
where tempemp.empno=emp.empno
July 28, 2004 at 11:38 pm
#516692
If the you are equating one value from the outer query but the subquery returns more than one value in that case this type of error occurs.
June 24, 2004 at 10:23 pm
#511897