Oracle条件判断列数量非where

sum(case when typename='测试' then 1 else 0 end)

原文地址:https://www.cnblogs.com/lingyao/p/6703844.html