我有两个选择查询,它们都给出了正确的结果:
SELECT SUM(value) AS "sum1" FROM table GROUP BY id1
和
SELECT SUM(value) AS "sum2" FROM table GROUP BY id1, id2
sum1
是所有sum2
-项的总和,我想要一个查询,它给我一个sum1
的结果和所有sum2
-项的GROUP_CONCT。但是,如何在GROUP_CONCT中为sum2
-items元素定义GROUP BY呢?
SELECT SUM(value) AS "sum1", GROUP_CONACAT(SUM(value) AS "sum2" ... (?))
FROM table GROUP BY id1
你应该使用子查询来解决它,使用下面的查询,我相信它会解决你的问题
select sum(t.part_sum) as sum1, group_concat(t.part_sum) as sum2 from (select sum(value) as part_sum from table group by id1, id2) as t