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

Try this

select

distinct TABLE1.ID ID,TABLE1.FIRESTNAME FIRSTNAME,LASTNAME,

Try this

select (Todate-FromDate) "NoOfdays" from dual.

Try this

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

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.