-通用sql写法select case when 列 is null then 0 end--sql server写法select isnull(列,0)--Oracle 写法select nvl(name,0)
