Oracle:
select NVL(sum(data),0)
SQLSERVER:
select ISNULL(sum(data),0)
MySql:
select IFNULL(sum(data),0)
通用:
select COALESCE(sum(data),0)
Oracle:
select NVL(sum(data),0)
SQLSERVER:
select ISNULL(sum(data),0)
MySql:
select IFNULL(sum(data),0)
通用:
select COALESCE(sum(data),0)