Running Totals

Simple Case

Each student has just one fee

select s1.student_id "id",
       s1.student_total_fee "fee1",
       sum(s2.student_total_fee) "fee2"
  from student s2,
       student s1
 where s1.student_id in ('133','330','925')
       and s2.student_id <= s1.student_id
       and s2.student_id in ('133','330' ,'925')
 group by s1.student_id,
          s1.student_total_fee
 order by 1;



ID       FEE1    FEE2
----- ------- -------
133       325     325
330       740    1065
925       610    1675
      -------
sum      1675