sqlserver保留两位小数

发布时间：2020-12-12 14:01:15 所属栏目：MsSql教程来源：网络整理

导读：sql?server中除法，会遇到除数为0的情况，且保留两位小数，写法如下：? select?case?when?num=0?then?0?else?convert(decimal(18,2),210.343/num)?end????as?结果?from?tabNumber ? select? [Carrier]?as?'承运人分组', count(*)?as?'张数', '0'?as?'出票效

sql?server中除法，会遇到除数为0的情况，且保留两位小数，写法如下：?
select?case?when?num=0?then?0?else?convert(decimal(18,2),210.343/num)?end????as?结果?from?tabNumber
?
select?
[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
?
?

select? [Carrier]?as?'承运人分组',count(*)?as?'张数','0'?as?'出票效率',sum(convert(decimal(18,SumPrice))?as?'票面价',[TaxPrice]))?as?'基建费',[OilPrice]))?as?'燃油费',SumPrice)?-?convert(decimal(18,[FlightBack]))?as?'实收费' ?from?[Order_FlightDetail]?where?[Carrier]?<>''?group?by?[Carrier]?order?by?count(*)?desc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!