Re: MySQL Rollup - All possible column super aggregations
> What I want to have is the summation for itemdistrict , it still gets split
> because of itemdealer. I just want it to be independent of it.
You can get that sum (or any other particular sum) in a straightforward Group By query, but not all of them in one query because MySQL doesn't have CUBE.
There are third party solutions eg Pentaho.
> Is there any way I can post pictures of data, I can be more clear in explaining.
If it can't be mapped from careful English to SQL, or if MySQL doesn't implement the feature, it can't be done.
Subject
Written By
Posted
Re: MySQL Rollup - All possible column super aggregations
June 05, 2017 07:51AM
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.