lazyfunctor
searching PlanetScale…
- 1.▲
- 2.▲
- 3.▲
- 4.▲
- 5.▲
- 6.▲
9 ms·
- 31.▲
- 32.▲
- 33.▲
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 - 34.▲
- 35.▲
- 36.▲
- 37.▲
- 38.▲
- 39.▲
- 40.▲
- 41.▲
- 42.▲
- 43.▲
- 44.▲
- 45.▲
- 46.▲
- 47.▲
- 48.▲
- 49.▲
- 50.▲
- 51.▲
- 52.▲
- 53.▲
- 54.▲
- 55.▲
- 56.▲