bagnallc Posted August 4, 2009 Share Posted August 4, 2009 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 4, 2009 Share Posted August 4, 2009 Not easily. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.