Question

表h中有abcde 5列,查询前4列分组第5列的合计. 如何写sql提高查询的速度.用一次h表的查询来达到查询目的

这个代码可以实现
但是查询效率低 ,可以一次遍历h表来达到查询目的吗
select 'a' as name, bp,sum (e) as e
FROM h
group by a
union all
select 'b' as name, zl,sum (e) as e
FROM h
group by b
union all
select 'c' as name, xz,sum (e) as e
FROM h
group by c
union all
select 'd' as name, qx,sum (e) as e
FROM h
group by d

Answer 1

看到后面的语句有点犯糊涂。如果是用前4列分组，第5列求和，则语句如下：
select a,b,c,d,sum(e) from h group by a,b,c,d;

Answer 2

1119541375