SQL保留兩位小數(shù)用法

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

selec
[Carrier] as '承運(yùn)人分組',
count(*) as '張數(shù)',
'0' as '出票效率',
sum(cast(SumPrice as int)) as '票面價(jià)',
sum(cast([TaxPrice] as int)) as '基建費(fèi)',
sum(cast([OilPrice] as int)) as '燃油費(fèi)',
sum(cast(SumPrice as int) - cast([FlightBack] as int)) as '實(shí)收費(fèi)'
from [Order_FlightDetail] group by [Carrier] order by count(*) desc

selec
[Carrier] as '承運(yùn)人分組',
count(*) as '張數(shù)',
'0' as '出票效率',
sum(convert(decimal(18,2),SumPrice)) as '票面價(jià)',
sum(convert(decimal(18,2),[TaxPrice])) as '基建費(fèi)',
sum(convert(decimal(18,2),[OilPrice])) as '燃油費(fèi)',
sum(convert(decimal(18,2),SumPrice) - convert(decimal(18,2),[FlightBack])) as '實(shí)收費(fèi)'
from [Order_FlightDetail] wher [Carrier] <>'' group by [Carrier] order by count(*) desc

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

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

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