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 **
红色部分为自己添加的列
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 **
红色部分为自己添加的列