by 김하진 [2007.06.27 18:07:52]
함 이렇게 해 보심이...
SELECT NVL(MIN(BANKTOT+100), 111) BANKVALUE FROM BANKHISTORY WHERE HISTORYNO = ( SELECT MAX(HISTORYNO) FROM BANKHISTORY WHERE PASSBOOKNUMNO = 11111 )
잘 될꺼에요.