count()满足条件才计数

为什么80%的码农都做不了架构师？>>>   

with a as
  (select 0 s
     from dual
   union all
   select 1 s
     from dual
   union all
   select 0 from dual)
 select CASE
          WHEN COUNT(DECODE(s, -1, 1)) = 0 THEN
           0
          ELSE
           -1
        END STATUS
   from a

哎，没得文化真可怕啊，看不懂别人的代码，测试一番才可知

转载于:https://my.oschina.net/goberl/blog/72801