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