MySQL Forums
Forum List  »  General

Re: How to show Subtotals?
Posted by: M Khosrowjerdi
Date: December 11, 2004 07:16AM

sbailey wrote:
> 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
July 27, 2004 12:26AM
Re: How to show Subtotals?
December 11, 2004 07:16AM
January 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.