Mysql query

I would like to be able to delect a number of fields from a mysql database and then sub total each column

I'm currently using something like

select
quantity,
price,
shipping charge

from
sales

group by

  date_time

;

I would like to sub total the select items each time the group by item changes.

Can someone please tell me what I need to add to get sub totals or even just totals to work.

I have experimented with sum() but this seems to show up as another column and the results look a bit odd.

Thanks

Paul

Hmm...if you want to select all of the products, and then the subtotals...the only way I could get it to work is with two selects...

SELECT date_time,quantity,price,shippingcharge FROM sales GROUP BY date_time;

SELECT date_time,sum(quantity) AS sum_quantity, sum(price) AS sum_price, sum(shippingcharge) AS sum_shippingcharge FROM sales GROUP BY date_time;

Would something like that work?

---John Holmes...