楼主:
select a1,total(a2,a3,...,a15) as a2,a3,...a15;
from a group by a1
是错误的,不信你就试一下,而
select a1, sum(a2+a3+a4+ ... + a15) as a2_a15_sum from a group by a1
才是对的.
sele a1,sum(a2+.....+a15) 是显示a1列和sum(a2+...+a15)两列
as a2_a15_sum 表示sum(a2+....+a15)这一列显示为a2_a15_sum,即字段名为 a2_a15_sum
from a 表示是A表
group by a1 表示是以a1作为分组统计。