oracle Count(0)-Count(0)
时间：2010-08-19 来源：gooliugle
1、两个统计量的减法：
select
(select count(*) from defect)-(select count(*) from defect where cljg like '%合格%' and cljg not like '%不合格%') as count
from dual
相关阅读 更多 +
排行榜 更多 +
时间：2010-08-19 来源：gooliugle
1、两个统计量的减法：
select
(select count(*) from defect)-(select count(*) from defect where cljg like '%合格%' and cljg not like '%不合格%') as count
from dual
