求教sql过滤各count值为0的记录的写法
展开全部
类似下面的一段语句
select t1.* ,
(select count(0) from ...) count_1,
(select count(0) from ...) count_2,
(select count(0) from ...) count_3
from table1 t1
where
(count_1 + count_2 + count3) > 0 //这个条件报错：ora-00904: "coun
select t1.* ,
(select count(0) from ...) count_1,
(select count(0) from ...) count_2,
(select count(0) from ...) count_3
from table1 t1
where
(count_1 + count_2 + count3) > 0 //这个条件报错：ora-00904: "coun
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
