1.case 表达式 when 值 then 2.case when 表达式 3.SELECT job,sal, CASE WHEN sal<1000 THEN 0 WHEN sal=1000 THEN sal*0.1 WHEN sal=2000 THEN sal*0.15 WHEN sal>=3000 THEN sal*0.2 ELSE sal END tax FROM emp;