下面给出一个case … when 函数的双层嵌套使用实例,用于查看逻辑回归预测模型的评估情况:
select mark , pre_mark ,count(*) from
(select emp_no,
label ,
pre,
case
when deptno = '01' then
(case when pre >= 0.42 then '高' else '低' end)
when deptno = '02' then
(case when pre >= 0.6 then '高' else '低' end)
end as pre_mark
from emp) group by mark , pre_mark