case...when...then...else...end

简单函数：

CASE SCORE WHEN 'A' THEN '优' ELSE '不及格' END
CASE SCORE WHEN 'B' THEN '良' ELSE '不及格' END
CASE SCORE WHEN 'C' THEN '中' ELSE '不及格' END

等同于，条件表达式函数

CASE WHEN SCORE = 'A' THEN '优'
     WHEN SCORE = 'B' THEN '良'
     WHEN SCORE = 'C' THEN '中' ELSE '不及格' END

select count(1)as count1, orgcode from ( select   
        hi.a001735   as empno,
        case when a001213 is not null then a001213
        when a001239 is not null then a001239
        when a001054 is not null then a001054 end as orgcode
       from aaaa hi