sql 聚合实例

select danjuh,yingshouje,zhekou,shishouje from yingye
union
select ('合计'), sum(yingshouje), sum(zhekou), sum(shishouje) from yingye
where jiezhangsj>'2007-05-01'