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 ? -- View this message in context: http://www.nabble.com/Simple-problem---tp18262458p18262458.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
