sql server中除法，会遇到除数为0的情况，且保留两位小数，写法如下：
selec case when num=0 then 0 else convert(decimal(18,2),210.343/num) end as 结果 from tabNumber
selec
[Carrier] as '承运人分组',
count(*) as '张数',
'0' as '出票效率',
sum(cast(SumPrice as int)) as '票面价',
sum(cast([TaxPrice] as int)) as '基建费',
sum(cast([OilPrice] as int)) as '燃油费',
sum(cast(SumPrice as int) - cast([FlightBack] as int)) as '实收费'
from [Order_FlightDetail] group by [Carrier] order by count(*) desc
selec
[Carrier] as '承运人分组',
count(*) as '张数',
'0' as '出票效率',
sum(convert(decimal(18,2),SumPrice)) as '票面价',
sum(convert(decimal(18,2),[TaxPrice])) as '基建费',
sum(convert(decimal(18,2),[OilPrice])) as '燃油费',
sum(convert(decimal(18,2),SumPrice) - convert(decimal(18,2),[FlightBack])) as '实收费'
from [Order_FlightDetail] wher [Carrier] <>'' group by [Carrier] order by count(*) desc
乐发网超市批发网提供超市货源信息,超市采购进货渠道。超市进货网提供成都食品批发,日用百货批发信息、微信淘宝网店超市采购信息和超市加盟信息.打造国内超市采购商与批发市场供应厂商搭建网上批发市场平台,是全国批发市场行业中电子商务权威性网站。
本文来源： SQL保留两位小数用法
