by jiyooon [Oracle 기초] [2013.08.01 11:34:30]
하나 더 물어볼게요 ;; 마지막 날짜 최종 잔액을 알고 싶은데 select max(sum(NVL(income,0)-NVL(outcome,0))over(order by date1, no) ) as total_balence)from ayrwhere sort=1group by date1;이렇게 했는데 안되서요....어떻게해야하나요?