3 ms·
I am not sure if I get your question. I think this query should work "select country, state, city, SUM(sales), SUM(profit) from foo group by country, state, c
by lazyfunctor 14y ago
I am not sure if I get your question.
I think this query should work
"select country, state, city, SUM(sales), SUM(profit) from foo group by country, state, city with rollup;"
for a table with country, state, city, sales, profit as columns
- sGrabber 14y agoThanks. Had tried this way taking multiple fields but it didnt work. Will try again and update you. Once again thanks for the inputs, really appreciate