SQL保留兩位小數用法

SQL保留兩位小數用法
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保留兩位小數用法