SELECT a, b, c, d, e, f, g, h, SUM(i), SUM(j) FROM tablename GROUP BY CONCAT(a, b, c, d), CONCAT(e, f), CONCAT(g, h) WITH ROLLUP |
|
我自己解决了,谁来拿分,解决方式,使用union
|
|
呀 大神 求带 |
SELECT a, b, c, d, e, f, g, h, SUM(i), SUM(j) FROM tablename GROUP BY CONCAT(a, b, c, d), CONCAT(e, f), CONCAT(g, h) WITH ROLLUP |
|
我自己解决了,谁来拿分,解决方式,使用union
|
|
呀 大神 求带 |