select ProjYear as 项目年度,ProjName as 项目名称,sum(TopNo) as 序号,sum(grossexpor) as 上年度出口统计额 from Projectsum Group By ProjYear,ProjName
union select ProjYear+'合计','',sum(TopNo) as 序号,sum(grossexpor) as 上年度出口统计额 from projectsum Group by ProjYear union select '总计','',sum(TopNo) as 序号,sum(grossexpor) as 上年度出口统计额 from projectsum
count 也一样
union select ProjYear+'合计','',sum(TopNo) as 序号,sum(grossexpor) as 上年度出口统计额 from projectsum Group by ProjYear union select '总计','',sum(TopNo) as 序号,sum(grossexpor) as 上年度出口统计额 from projectsum
count 也一样
(select * from t1
union
select * from t2) as a
insert a values ('12345')
create table b(a char(5))
insert b values ('67890')
insert b values ('12345')select 记录数=count(*) from
(select * from a
union all
select * from b) as tdrop table a,b--结果
记录数
-----------
3