With Rollup

[bagnallc]

I know of the with rollup feature but want to know if it can be implemented against all columns to produce totals against all possibilities.

 

For example -

 

select col1, col2, count(*) as Sum from tb group by col1, col2 with rollup

 

returns

 

col1.Value1, col2.Value1, Sum

col1.Value1, col2.Value2, Sum

col1.Value1, NULL, Sum

col1.Value2, col2.Value1, Sum

col1.Value2, col2.Value2, Sum

col1.Value2, NULL, Sum

NULL, NULL, Sum

 

I want these additional rows to also be included as part of a query

 

NULL, col2.Value1, Sum

NULL, col2.Value2, Sum

 

Is it possible to return all this data using MySQL?

[fenway]

Not easily.