SQL保留兩位小數(shù)用法
sql server中除法，會遇到除數(shù)為0的情況，且保留兩位小數(shù)，寫法如下：
selec case when num=0 then 0 else convert(decimal(18,2),210.343/num) end as 結(jié)果 from tabNumber

selec
[Carrier] as '承運人分組',
count(*) as '張數(shù)',
'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 '張數(shù)',
'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

樂發(fā)網(wǎng)超市批發(fā)網(wǎng)提供超市貨源信息,超市采購進(jìn)貨渠道。超市進(jìn)貨網(wǎng)提供成都食品批發(fā),日用百貨批發(fā)信息、微信淘寶網(wǎng)店超市采購信息和超市加盟信息.打造國內(nèi)超市采購商與批發(fā)市場供應(yīng)廠商搭建網(wǎng)上批發(fā)市場平臺,是全國批發(fā)市場行業(yè)中電子商務(wù)權(quán)威性網(wǎng)站。

本文內(nèi)容整合網(wǎng)站：百度百科、知乎、淘寶平臺規(guī)則

本文來源： SQL保留兩位小數(shù)用法