oracle
select nvl(字段名,0) from 表名;
sqlserver
select isnull(字段名,0) from 表名;
mysql
select ifnull(字段名,0) from 表名;
select nvl(字段名,0) from 表名;
select isnull(字段名,0) from 表名;
select ifnull(字段名,0) from 表名;
转载于:https://www.cnblogs.com/ming-blogs/p/10619383.html