一个查询的问题怎么写

Question

Select  a.rq,a.fdkc,a.ckkc,a.lskc,a.yfk,a.ysk,a.yhck,a.xj,a.jk,a.dk,a.zje
From finance_zje a 
Where datediff(day,rq,'2003-4-21')>=0 and datediff(day,rq,'2003-4-7')<=0
order by a.rq
COMPUTE sum(a.fdkc),sum(a.ckkc),sum(a.lskc),sum(a.yfk),sum(a.ysk),
sum(a.yhck),sum(a.xj),sum(a.jk),sum(a.dk),sum(a.zje)

Answer 1

Select  a.rq as 合计,a.fdkc,a.ckkc,a.lskc,a.yfk,a.ysk,a.yhck,a.xj,a.jk,a.dk,a.zje
From finance_zje a 
Where datediff(day,rq,'2003-4-21')>=0 and datediff(day,rq,'2003-4-7')<=0
union all 
Select '20031212' as rq,sum(x.fdkc)fdkc,sum(x.ckkc)ckkc,sum(x.lskc)lskc,sum(x.yfk)yfk,sum(x.ysk)ysk,
sum(x.yhck)yhck,sum(x.xj)xj,sum(x.jk)jk,sum(x.dk)dk,sum(x.zje)zje
From 
(Select  a.rq,a.fdkc,a.ckkc,a.lskc,a.yfk,a.ysk,a.yhck,a.xj,a.jk,a.dk,a.zje
From finance_zje a 
Where datediff(day,rq,'2003-4-21')>=0 and datediff(day,rq,'2003-4-7')<=0)x
order by rq desc

Answer 2

把第一个查询中的rq改为字符型就可以了
select convert(varchar,a.rq) as rq,...
union all
select '20021201'...