Question

用SQL查询一批数据，怎么在最后一行增加个数字合计

Answer 1

select mc,sum(sl) as 数量,sum(jie) as 金额,b.xm
from a,b where a.id=b.id and a.id=1 group by a.mc,b.xm
union
select '合计' as mc,sum(sl) as 数量,sum(jie) as 金额,b.xm
from a,b where a.id=b.id and a.id=1
group by a.mc
order by mc