在sql server中，计算两条sql语句结果相除的百分比

1.有两条sql语句需要相除求出百分比，如下：

select COUNT(1) from Journal where DATEDIFF(dd,dateadd(day, -1, getdate()),logintime)=0 
select count(1) from users where 是否使用=1

 

 

2.把这两条sql语句分别赋值给f1和f2，再用select查询出来作为一张表备用，如下

 select (select COUNT(1) from Journal where DATEDIFF(dd,dateadd(day, -1, getdate()),logintime)=0 ) as f1,
(select count(1) from users where 是否使用=1) as f2

3.最后运算

 select (CONVERT(float,f2)/f1)*100 as 百分比

from (
select(select COUNT(1) from Journal where DATEDIFF(dd,dateadd(day, -1, getdate()),logintime)=0 ) as f1,
          (select count(1) from users where 是否使用=1) as f2

) as t