试试子查询吧
select p.a2,p.a3,t.a5, t.a6 from (select sum(a2) a2,sum(a3) a3,a6 from A where a1='33' and group by a6) p, (select a5,a6 from A where a1='33') t
where p.a6=t.a6 order by a5
select p.a2,p.a3,t.a5, t.a6 from (select sum(a2) a2,sum(a3) a3,a6 from A where a1='33' and group by a6) p, (select a5,a6 from A where a1='33') t
where p.a6=t.a6 order by a5
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货