我现在执行这几条这样的语句:
select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx得到的是:
km rs
---- -------------
yw 1200
sx 3600我想得到这样的结果:
km rs
---- -------------
yw 1200
sx 3600
zs 4800求上面两个科目人数的总数,有谁能告诉我怎么写这个语句,谢谢
select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx得到的是:
km rs
---- -------------
yw 1200
sx 3600我想得到这样的结果:
km rs
---- -------------
yw 1200
sx 3600
zs 4800求上面两个科目人数的总数,有谁能告诉我怎么写这个语句,谢谢
select 'sx' as km,count(*) as rs from sx union
select 'zs',sum(rs) from
(select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx )
select @yw_rs = count(*) from yw
select @sx_rs = count(*) from sx
select 'yw' as km,@yw_rs as rs
union all
select 'sx' as sx,@sx_rs as rs
union all
select 'zs' as zs,@yw_rs+@sx_rs as rs
select 'sx' as km,count(*) as rs from sx union all
select 'zs',sum(rs) from
(
select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx
)as a
select 'sx' as km,count(*) as rs from sx union
select 'zs',
(select count(*) from yw + select count(*) from sx )
select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx union
select 'zs',
(select count(*) from yw) + (select count(*) from sx) as rs
改下也对.
(select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx )A
(select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx )A
(select 'yw' as km,count(*) as rs from yw union
select 'sx' as km,count(*) as rs from sx )A