单项选择题
查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）
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';
相关考题
-
单项选择题
查询出EMP表中COMM字段为空的记录（）
A.select * from emp where comm='';
B.select * from emp where comm=null;
C.select * from emp where nvl(comm)=0;
D.select * from emp where comm is null;
E.select * from emp where nvl(comm,0)=0; -
单项选择题
取出工资在2000到3000元（包括上下限）之间的员工（）
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; -
单项选择题
查询出所有名字以’S’开始的员工（）
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_';
