select f,g,sum(c) as c,sum(d) as d from table group by f,g只能列出分组的字段,如果分组字段中有本表的主键,那么可以 select a,b,c,d,e,f,g from ( select f,g,sum(c) as c,sum(d) as d from table group by f,g ) TA inner join Table on Table.f = TA.f
SELECT a,b,c, sum(c) as c, sum(d) as d FROM Table GROUP BY f,g试试
你说的其他字段是指,f,g相同的时候,其他字段如a,b,e也相同 select max(a) as a,max(b) as b,c=sum(c),d=sum(d),max(e) as e from table group by f,g
你的 group by 里必须包含a,b,e,否则语法错误。
select a,b,c=sum(c),d=sum(d),e,f,g from table group by f,g,a,b,e
select a,b,c=sum(c),d=sum(d),e from table group by a,b,e,f,g
select a,b,c,d,e,f,g from
(
select f,g,sum(c) as c,sum(d) as d from table group by f,g
) TA inner join Table on Table.f = TA.f
select max(a) as a,max(b) as b,c=sum(c),d=sum(d),max(e) as e from table group by f,g