Skip navigation links

MySQL Forums :: General :: How to show Subtotals?


Advanced Search

How to show Subtotals?
Posted by: sbailey ()
Date: July 27, 2004 12:26AM

How can you show SUBTOTALS in the same column as the data, NOT in a separate column?

In my SELECT statement I have GROUP BY. I need to SUBTOTAL each resulting group, in the same column as the data. See the subtotals 700 and 200 under Field 3 below (I really have 21 columns). Also I must show one blank row after each resulting group:

Field1 Field2 Field3 Field4
entry1 data2.1 100 data4.1
entry2 data2.2 400 data4.2
entry3 data2.3 200 data4.3
......................700

entry4 data2.4 500 data4.4
entry5 data2.5 300 data4.5
......................200

How can you show subtotals using MySQL ONLY, without also learning something else like PHP or PERL ? I'm new to databases, just learning MySQL, and it will be a long time before I can learn anything else. Thank you for any help.



Options: ReplyQuote


Subject Written By Posted
How to show Subtotals? sbailey 07/27/2004 12:26AM
Re: How to show Subtotals? M Khosrowjerdi 12/11/2004 07:16AM
Re: How to show Subtotals? Mike Hillyer 01/05/2005 03:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.