--声明个数变量
declare @a int ;
declare @b int ;
--查询数量并赋值
select @a = count(1) from [IFengKe].[dbo].[Media] with(nolock) where IsMigration =0 and [OssRequestId] like '%https://obs-d1%'
select @b= count(1) from [IFengKe].[dbo].[Media] with(nolock) where IsMigration =1
select @a,@b
--计算百分比
select cast(@b as Decimal(18,4)) /( cast(@a as Decimal(18,4)) + cast(@b as Decimal(18,4)))
select cast( cast(@b as Decimal(18,4)) /( cast(@a as Decimal(18,4)) + cast(@b as Decimal(18,4)))as Decimal(18,4))