there are lot of ways in sql to diplay the running sums and sums(using group by,compute by, compute etc.,). Ok I have written one like. but How to create the resultset containing those running sums.