34,593
社区成员
发帖
与我相关
我的任务
分享
select ltrim(cast(11*100.0/36 as dec(18,2)))+'%'
/*
------------------------------------------
30.56%
(1 行受影响)
*/
declare @a int
set @a = 36
declare @b int
set @b = 11
select ltrim(cast(@b*100.0/@a as dec(9,2)))+'%'