Re: [sqlite] Sum of various rows

[jose isaias cabrera]

"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

[Michael Black]

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

[jose isaias cabrera]

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