[sqlite] Re: How do I do this

[Igor Tandetnik]

Vishal Mailinglist <list-p2Y/[EMAIL PROTECTED]> wrote:

Did not know how to do this on a database that I have in sqlite

sno | id | amount
1    | 1 |  200
2    | 1 | 300
3   |  2 | 100
4  | 2 | 100
5 | 1 | 500

how could I subtract the sno 1 id 1 and sno 2 id 1 amount .

select
   (select amount from tableName where sno=1 and id=1) -
   (select amount from tableName where sno=2 and id=1);

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------