Question

sql server 2个查询结果相除

select count(*) as a from table1
select count(*) as b from table2
如何让查询的结果相除？

Answer 1

declare @a float
declare @b float
select @a= count(*) from table1
select @b = count(*) from table2
select @a/@b

楼上返让的方法，如果只是COUNT条数，没有小数点啊。。。 要转备世扮格式：仿灶
select a.a/b.b from
(select cast(count(*)as float) as a from table1) as a,
(select cast(count(*)as float) as b from table2) as b

Answer 2

select a.a/b.b from (
select count(*) as a from table1) a,
(select count(*) as b from table2) b

Answer 3

select TOP 1 (select count(*) as a from table1) / (select count(*) as b from table2) from table1