mssql如何把两个查询合并成一个

Question

sql语句1：select count(Azcount) as 新 from StatisticsInfon where addtime between '2012-11-14 00:00:00' and '2012-11-14 23:59:59' sql语句2：select count(Azcount) as 旧 from StatisticsInfon where addtime between '2012-11-13 00:00:00' and '2012-11-13 23:59:59' 用union合并之后，只能显示一列。 如何变成这种一个结果集的效果？ 新 旧 12 12

Answer 1

select  sum(case when addtime between '2012-11-13 00:00:00' and '2012-11-13 23:59:59' then 1 else 0 end) as 旧,sum(case when addtime between '2012-11-14 00:00:00' and '2012-11-14 23:59:59' then 1 else 0 end) as 新

from StatisticsInfon

Answer 2

select count(Azcount) as 新, (

select count(Azcount) as 旧 from StatisticsInfon

where addtime between '2012-11-13 00:00:00' and '2012-11-13 23:59:59'

)from StatisticsInfon

where addtime between '2012-11-14 00:00:00' and '2012-11-14 23:59:59'

Answer 3

SELECT  *
FROM    ( SELECT    COUNT(*) 新
          FROM      StatisticsInfon
          WHERE     xxxx
        ) a ,
        ( SELECT    COUNT(*) 旧

          FROM      StatisticsInfon
          WHERE     xxxxxx

        ) b