SQLServer_除法_百分比_小数计算

SQLServer_除法_百分比_小数计算
sql

SELECT Convert(decimal(18,2),-1604) /Convert(decimal(18,2),(27615-(-1604))) *100
SELECT 1604/((27615+1604)*1.0) *100
select cast(round((1604/((27615+1604)*1.0))*100,2) as varchar)+'%'
select cast(round(5.48957869879145,2) as varchar)+'%'

-5.4895786987918820
5.48957869879100
5.49000000000000%
5.49000000000000%

select CONVERT(decimal(18,2),1604 *1.0/(27615+1604)*100)
select  CAST(CAST(1604*1.0*100/(27615+1604) as decimal(10,2)) as varchar(50)) +'%'

5.49
5.49%

select Round(2.126412,3)
select Convert(decimal(18,3),2.126412)

2.126000
2.126

转载