Re: [sqlite] Sum of various rows
"Michael Black" wrote... create table test (id,invoice,transfer,price); insert into test values(10,500,200,0); insert into test values(200,300,300,200); insert into test values(334,3000,200,3000); select sum(invoice),sum(transfer),sum(price) from test where id in (10,200,334); 3800|700|3200 So easy... darn it! :-) Muchas gracias. josé ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sum of various rows
create table test (id,invoice,transfer,price); insert into test values(10,500,200,0); insert into test values(200,300,300,200); insert into test values(334,3000,200,3000); select sum(invoice),sum(transfer),sum(price) from test where id in (10,200,334); 3800|700|3200 Michael Black ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sum of various rows
Greetings. Very newbie question... I have these records... id,invoice, transfer, price 1,0,0,0 ... 10,500.00,200.00,0.00 ... 200,300,300, 200 ... 334,3000, 200,3000 ... what I would like to do is to add invoice, transfer and price. I have this, SELECT sum(invoice),sum(transfer),sum(price) where id = 10,200,334; Of course, it does not work. Any help would be greatly appreciated. Thanks. josé ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users