Re: MySQL Rollup - All possible column super aggregations

[Rathi Rao]

Hi Peter,

My question was when I write the query with the group by with rollup as
group by itemtypeid,unitid,dealerid,districtid with rollup

It does not generate the aggregation for itemtypeid and districtid alone

I want to understand how must I do this

Please do let me know as to what other information I can provide

Thanks
Rathi