Convert(numeric(18,0), (Case when d.OrgTotalPrice <> 0 Then (d.ActTotalPrice / OrgTotalPrice)*100 else 0 end )) as [%]
sql server 将小数转化为百分比
最新推荐文章于 2023-07-14 14:25:54 发布
Convert(numeric(18,0), (Case when d.OrgTotalPrice <> 0 Then (d.ActTotalPrice / OrgTotalPrice)*100 else 0 end )) as [%]