select a,b,max(c),max(d),max(e),max(f),max(g) from (
select a,b,avg(c) as c,avg(d) as d,avg(e) as e,avg(f) as f,avg(g) as g from
表AA group by a,b
) a
group by a,b
order by a,b
select a,b,avg(c) as c,avg(d) as d,avg(e) as e,avg(f) as f,avg(g) as g from
表AA group by a,b
) a
group by a,b
order by a,b
2、逻辑混乱试试:select
Max(m.c),
Max(m.d),
Max(m.e),
Max(m.f),
Max(m.g)
from
(Select a,b,avg(c) as c,avg(d) as d,avg(e) as e,avg(f) as f,avg(g) as g from AA group by a,b) m