select a,b,c ,case when c is null then 0 else 1 end as d from tablename ?
SQL -- 判断字段值是否为空,假如是空的话,就赋值为0,假如不为空,则赋值就为1
最新推荐文章于 2022-09-12 03:36:42 发布
select a,b,c ,case when c is null then 0 else 1 end as d from tablename ?