oracle中数值类型为null时转换为0 nvl()

 round(sum(NVL(ydmj,0)/10000),4) as ydmj  NVL(ydmj,0)中当jdmj为null时返回0

 

 

select count(XMBH) as xmsl ,round(sum(XMQRHJMJ/10000),4) as kfzlmj ,'开发整理面积' as ms from **

红色部分为自己添加的列

展开阅读全文

没有更多推荐了,返回首页