Question

如何在sql语句中把为null的值替换成0

Answer 1

select id,case when name is null then 0 when name='' then 1 else name end from a;