sql语句如何统计2个表中多个字段不为空的总记录数？
展开全部
select count(a.*) from a b
where a.a1=b.b1 and (a.a2 is not NULL) and (a.a3 is not NULL) and
(b.b2 is not NULL) and (b.b3 is not NULL) .....
where a.a1=b.b1 and (a.a2 is not NULL) and (a.a3 is not NULL) and
(b.b2 is not NULL) and (b.b3 is not NULL) .....
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
