查询一条记录有多少字段为空
一跳记录有6个字段 查询有几个字段是空的
select case when col1 is null then 1 else 0 end +
case when col2 is null then 1 else 0 end +
...
case when col6 is null then 1 else 0 end sum0
from tab
where ...
case when col2 is null then 1 else 0 end +
...
case when col6 is null then 1 else 0 end sum0
from tab
where ...
温馨提示:答案为网友推荐,仅供参考
第1个回答 2012-08-01
where website is null