On Tue, 05 Mar 2013 00:26:04 -0500, Igor Tandetnik wrote: > > select ID, PostDate, Amount, > (case when Amount < 0 then -Amount else null end) Withdrawal, (case when > Amount >= 0 then > Amount else null end) Deposit, (select sum(Amount) from MyTable t2 where > t2.ID <= t.ID) > Balance from MyTable t order by ID;
Nice - thanks much K _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
