you can do it with a subquery, like select o.date, (select sum(credit - debit) from bank i where i.rowid < o.rowid) from bank o order by rowid;
but it would be _much_ more efficient to handle it in your host application as you loop through the data. Notice that I used rowid instead of date 'cause rowid will be more precise, whereas dates could be duplicated and may not give desired results. This assumes records are always inserted in chronological order. HTH, Sam ----------------------------------------------------------------- We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] On Thu, Jul 3, 2008 at 12:03 PM, c.panel <[EMAIL PROTECTED]> wrote: > > Hello, > I'm learning SQL and have some difficulties to resolve some simple problems > with SQL. > > one example: > Suppose I have a table with column DATE, CREDIT, DEBIT > I want to create a new column that is the balance of account (ACCOUNT). > My first approach is to index the table on dates, then starting with 0, > then > ACCOUNT = preceding ACCOUNT + CREDIT - DEBIT. > But how can I do this in SQL with no cursor ? > > I'm afraid of complexity of SQL for simple problems. > What do you think of this ? > > Does SQL is reserved for one sort of database management ? > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
