A、select sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp;
B、select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;
C、select sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp;
D、select sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;
更多“对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）”相关的问题
A、v_sal emp%rowtype; B、v_sal emp.sal%type; C、v_sal emp.sal.%type; D、v_sal %type(emp.sal); E、v_sal (emp.sal)%type;
A、Select * From Emp B、Select * From Emp Where EmpNO Like '%%' C、Select * From Emp Where Name = '%%' D、Select * From Emp Where Name Like '%%'
A、select * from emp wher sal in (2000,3000); B、select * from emp wher sal like (2000,3000); C、select * from emp wher sal = (2000,3000); D、select * from emp wher sal between 2000 and 3000;
A、Select *From Emp Where Job>="办事员" B、Select* From Emp Where Job==’办事员’ C、Select* From Emp Where Job<>’办事员’ D、Select* From Emp Where Job!=’办事员’
A、A.Select * From Emp Where EmpNO In('791','792','793') B、B.Select * From Emp Where EmpNO ='791' Or EmpNO='792' OR EmpNO='793' C、C.Select * From Emp Where EmpNO >='791' And EmpNO<='793' D、D.Select * From Emp Where EmpNO >'791' And EmpNO<'793'
A、Select * From Emp Where EmpNO Not In('791','792','793') B、Select * From Emp Where EmpNO !='791' AND EmpNO!='792' And EmpNO='793' C、Select * From Emp Where EmpNO <>'791' AND EmpNO<>792' And EmpNO=<>793' D、Select * From Emp Where EmpNO =!'791' AND EmpNO =!'792' And EmpNO =!'793'
A、elect * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31' B、Select * From Emp Where Between In '1981-1-1' And <'1981-12-31' C、Select * From Emp Where Between In '1981-12-31' And <'1981-1-1' D、Select * From Emp Where HirDate>='1981-1-1' NOT HirDate <='1981-12-31'
A、A.GRANT CHANGE ON SCOTT.EMP TO SA B、B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA C、C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA D、D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
A、No change is required to achieve the desired results. B、SELECT ename, sal, 12*(sal+100) FROM emp; C、SELECT ename, sal, (12*sal)+100 FROM emp; D、SELECT ename, sal+100,*12 FROM emp;
客服
TOP
查看正确答案
