网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
关于HQL的聚合函数使用，说法正确的是（）。
- A、select count(*) from Dept d用于统计部门个数
- B、select sum(e.salary) from Emp e用于汇总员工工资总额
- C、select max(e.hiredate) from Emp e用于找到最新入职的员工的入职时间
- D、select min(e.hiredate) from Emp e用于找到最早入职的员工的入职时间
参考答案
更多 “关于HQL的聚合函数使用，说法正确的是（）。A、select count(*) from Dept d用于统计部门个数B、select sum(e.salary) from Emp e用于汇总员工工资总额C、select max(e.hiredate) from Emp e用于找到最新入职的员工的入职时间D、select min(e.hiredate) from Emp e用于找到最早入职的员工的入职时间” 相关考题
考题
以下语句错误的是( )A.select sal+1 from emp;B.select sal*10,sal*deptno from emp;C.不能使用运算符号D.select sal*10,deptno*10 from emp;
考题
以下语句不正确的是( )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
考题
以下说法错误的是( )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;
考题
统计每个部门中人数( )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;
考题
取出工资在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;
考题
列出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;
考题
限制从EMP表中只选出前5条记录的查语句为()。
A.SELECT TOP 5 * FROM EMPB.SELECT DISTINCT 5 * FROM EMPC.SELECT * FROM EMP WHERE ROWNUM6D.SELECT * FROM EMP WHERE ROWNUM=5
考题
找出emp表中的dept表没有的dept_no 使用Exists方式实现 即改写select * from emp a where a.dept_no not in (select b.dept_no from dept b)
考题
某企业部门关系模式Dept（部门号，部门名，负责人工号，任职时间），员工关系模式EMP（员工号，姓名，年龄，月薪资，部门号，电话，办公室）。部门和员工关系的外键分别是（ ）。查询每个部门中月薪资最高的员工号、姓名、部门名和月薪资的SQL查询语句如下：SELECT员工号，姓名，部门名，月薪资FROM EMP Y,DeptWHERE（请作答此空）AND月薪资=（SELECT Max（月薪资）FROM EMP Z WHERE（ ）A.Y．部门号=Dept.部门号
B.EMP.部门号=Dept.部门号
C.Y.员工号=Dept.负责人工号
D.EMP.部门号=Dept.负责人工号
考题
某企业部门关系模式Dept（部门号，部门名，负责人工号，任职时间），员工关系模式EMP（员工号，姓名，年龄，月薪资，部门号，电话，办公室）。部门和员工关系的外键分别是（ ）。查询每个部门中月薪资最高的员工号、姓名、部门名和月薪资的SQL查询语句如下：SELECT员工号，姓名，部门名，月薪资FROM EMP Y,DeptWHERE（ ）AND月薪资=（SELECT Max（月薪资）FROM EMP Z WHERE（请作答此空）A.Z.员工号=Y.员工号
B.Z.员工号=Y.负责人工号
C.Z.部门号=部门号
D.Z.部门号=Y.部门号
考题
使用HQL查询所有部门信息，以下正确的是（）。A、from DeptB、select*from cn.jbit.demo.entity.DeptC、select Dept from cn.jbit.demo.entity.Dept dD、select d from Dept d
考题
查询出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';
考题
语句SELECT * FROM dept WHERE NOT EXISTS （SELECT * FROM emp WHERE deptno=dept.deptno）执行后的结果为（）A、只显示存在于EMP表中的部门全部信息B、只显示不存在于EMP表中的部门全部信息C、未返回任何数据D、显示DEPT表中的全部信息
考题
如果要将查询的职工信息保存到数组tms中，应输入语句（）。A、SELECT＊FROM职工INTO ARRAY tinsB、SELECT＊FROM职I INTO CURSOR tinsC、SELECT＊FROM职I INTO DBF tinsD、SELECT＊FROM职工INTO TABLE tms
考题
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
考题
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
考题
取出工资在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_';
考题
Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）A、SELECT * FROM emp_dept_vu;B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E、None of the statements produce an error; all are valid.
考题
限制从EMP表中只选出前5条记录的查语句为（）。A、SELECT TOP 5 * FROM EMPB、SELECT DISTINCT 5 * FROM EMPC、SELECT * FROM EMP WHERE ROWNUM6D、SELECT * FROM EMP WHERE ROWNUM=5
考题
Which SQL statement returns a numeric value?（）A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;B、SELECT ROUND(hire_date) FROM EMP;C、SELECT sysdate-hire_date FROM EMP;D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;
考题
Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）A、SELECT * FROM emp_dept_vu;B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E、None of the statements produce an error; all are valid.
考题
列出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;
考题
多选题关于HQL的聚合函数使用，说法正确的是（）。Aselect count(*) from Dept d用于统计部门个数Bselect sum(e.salary) from Emp e用于汇总员工工资总额Cselect max(e.hiredate) from Emp e用于找到最新入职的员工的入职时间Dselect min(e.hiredate) from Emp e用于找到最早入职的员工的入职时间
考题
单选题列出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;
考题
单选题查询出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';
考题
( 难度：中等)以下哪些Mysql语句是正确的？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;E.select * from where deptno=1 group by sal;
热门标签
最新试卷
