Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- newbie sql question
November 16, 2006, 9:48 pm
rate this thread
select item_no, sum(price), count(*) from production where date >
'2006-11-15' group by item_no;
item_no sum(price) count(*)
27714 327.6 6
29582 269.64 4
38599 476.34 6
Is there a way that I can get the total of the sum(price)? Do I need to do
this in PHP?
Thanks for any help that you might be able to provide.
- » Help wanted - Struggling with 'updated'-NOW() field
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum