Comments by ravitechguy (Top 2 by date)

ravitechguy 28-Jan-11 9:52am View

Try Below:
Select a.tran_amount, a.rowid
from
(select TRAN_AMOUNT AS CLOSING_BAL,
ROWID As Rownumber
From LOANTRAN
WHERE TRAN_DATE IN (select AC_CLOSEDT from LNMASTER where AC_NO BETWEEN 100 AND 200)
Order by ROWID) a
where a.rowid in (SELECT MAX(ROWID) FROM LOANTRAN WHERE TRAN_ACNO BETWEEN 100 AND 200)

ravitechguy 28-Jan-11 9:46am View

Do you have any other columns in LOANTRAN table which will record date entry into the table.

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid