查询结果问题?

用select查询,
select sum(字段1+字段2-字段3) from ...
其中字段3中有空值,结果显示为空,怎样才能把字段3中的空设为0,不能修改数据库中原数据,怎么实现?
---------------------------------------------------------------

isnull(字段3,0)
---------------------------------------------------------------

select sum(字段1+字段2-isnull(字段3,0)) from ...

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus