考试
2021-02-25 12:21:21

(单选题)对于雇员表(EMP)中的员工薪水(SAL)进行分级

题目描述

Aselect sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp;

Bselect sal,decode(sal,3000,'A',2000,'B','C') grade from emp;

Cselect sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp;

Dselect sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;

答案解析

[db:答案解析]

C

加载中...
AI正在思考中,请稍候...