单选题取出工资在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;

题目

单选题

取出工资在2000到3000元（包括上下限）之间的员工（）

select * from emp wher sal in (2000,3000);

select * from emp wher sal like (2000,3000);

select * from emp wher sal = (2000,3000);

select * from emp wher sal between 2000 and 3000;

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

以下说法错误的是( )

A.SELECT max(sal),deptno,job FROM EMP group by sal;

B.SELECT max(sal),deptno,job FROM EMP group by deptno;

C.SELECT max(sal),deptno,job FROM EMP;

D.SELECT max(sal),deptno,job FROM EMP group by job;

正确答案：C

第2题：

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

参考答案：B

第3题：

以下语句错误的是( )

A.select sal+1 from emp;

B.select sal*10,sal*deptno from emp;

C.不能使用运算符号

D.select sal*10,deptno*10 from emp;

正确答案：C

第4题：

执行如下两个查询，结果为（） Select ename name，sal salary from emp order by salary Select ename name，sal“salary”from emp order by sal asc

A、两个查询结果完全相同
B、第一个查询正确，第二个查询错误
C、两个查询结构不同
D、第二个查询正确，第一个查询错误

正确答案:A

第5题：

列出EMP表中,从事每个工种(JOB)的员工人数()

A.select job from emp;

B.select job,count(*) from emp;

C.select distinct job,count(*) from emp;

D.select job,count(*) from emp group by job;

E.select job,sum(empno) from emp group by job;

参考答案：D

第6题：

统计每个部门中人数( )

A.SELECT SUM(ID) FROM EMP GROUP BY DEPTNO;

B.SELECT SUM(ID) FROM EMP ORDER BY DEPTNO;

C.SELECT COUNT(ID) FROM EMP ORDER BY DEPTNO;

D.SELECT COUNT(ID) FROM EMP GROUP BY DEPTNO;

正确答案：D

第7题：

取出工资在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;

参考答案：D

第8题：

以下语句不正确的是( )

A.select * from emp;

B.select ename,hiredate,sal from emp;

C.select * from emp order deptno;

D.select * from where deptno=1 and sal<300;

正确答案：C

第9题：

以下查询语句合法的是哪三项?()

A.select empno ,sum(sal) from scott.emp group by deptno

B.select * from scott.emp

C.select sum(sal) from scott.emp group by deptno

D.select count(empno) from scott.emp

第10题：

数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float），Comm（奖金，Float，可为空）。查询出雇员编号不为791，792，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,B,C

单选题取出工资在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;

题目

相似问题和答案

更多相关问题

相关内容