Re: [sqlite] More noobie questions

2013-03-04 Thread Kai Peters
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

[sqlite] More noobie questions

2013-03-04 Thread Kai Peters
Hi all, given a table ID integer primary key, PostDate date, Amount int with data ID PostDateAmount --- 100 2013-01-01 -500 101 2013-01-02 1000 1022013-01-03