可以通过修改查询语句就能实现。 针对oracle: select decode(result,null,0,result) from (select sum(XX) as result from dual) 这样选出来的不会有null的情况。 通用的SQL,Postgre,Oracle.... select CASE WHEN result = null THEN 0 else result END AS result from (select sum(XX) as result from dual)
针对oracle:
select decode(result,null,0,result) from (select sum(XX) as result from dual)
这样选出来的不会有null的情况。
通用的SQL,Postgre,Oracle....
select CASE WHEN result = null THEN 0 else result END AS result from (select sum(XX) as result from dual)