在员工表emp中，查询出员工一年的薪水加100块的SQL语句是以下哪一个？（）

A.select * from emp where hiredate＞=‘19820101‘;

B.select * from emp where hiredate＞=to_char(‘19820101‘,‘YYYYMMDD‘);

C.select * from emp where to_date(hiredate,‘YYYYMMDD‘)＞=‘19820101‘;

D.select * from emp where to_char(hiredate,‘YYYYMMDD‘)＞=‘19820101‘;

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;

A.select * from emp where ename in ‘S%‘;

B.select * from emp where ename=‘S%‘;

C.select * from emp where ename like ‘S%‘;

D.select * from emp where ename like ‘S_‘;

A.SELECT ENAME FROM EMP WHERE MGR=NULL;

B.SELECT ENAME FROM EMP WHERE MGR IS NULL;

C.SELECT ENAME FROM EMP WHERE MGR=0;

D.SELECT ENAME FROM EMP WHERE MGR=’’;

A.SELECT empno,ename FROM empWHERE empno=(SELECT empno FROM dept WHERE dname="研发部")

B.SELECT empno,ename FROM empWHERE deptno=(SELECT deptno FROM dept WHERE dname='研发部')

C.SELECT empno,ename FROM empWHERE deptno=(SELECT * FROM dept WHERE dname='研发部')

D.SELECT empno,ename FROM deptWHERE deptno=(SELECT deptno FROM emp WHERE dname="研发部")

A.selectt1.emp_name,t2.salfromempt1,salt2wheret1.emp_id=t2.emp_id

B.selectt1.emp_name,t2.salfromempt1leftjoinsalt2ont1.emp_id=t2.emp_id

C.selectt1.emp_name,t2.salfromempt1whereemp_idin(selectt2.emp_idfromsalt2)

D.selectt1.emp_name,t2.salfromempt1leftjoinsalt2wheret1.emp_id=t2.emp_id

A.select deptno,ename,sal from emp a where sal＞ (select avg(a.sal) from emp where deptno=a.deptno);

B.select deptno,ename,sal from emp a where sal＞ (select avg(sal) from emp where deptno=a.deptno);

C.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and a.sal＞avg(b.sal);

D.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and b.sal＞avg(a.sal);