问题

Evaluate the SQL statement:1 SELECT a.emp_name a.sal a.dept_id b.maxsal2 FROM employees

Evaluate the SQL statement:1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal2 FROM employees a,3 (SELECT dept_id, MAX(sal) maxsal4. FROM employees5 GROUP BY dept_id) b6 WHERE a.dept_id = b.dept_id7 AND a. asl < b. maxsal;What is the result of the statement？（）

A. The statement produces an error at line 1.

B. The statement produces an error at line 3.

C. The statement produces an error at line 6.

D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

参考答案

您可能感兴趣的试题

如果要在藏书中查询“电子工业出版社”和“清华出版社”的图书，请对下面的SQL语句填空。SELE

答案解析
在Access中已建立了“学生”表，表中有“学号”“姓名”性别”和“入学成绩”等字段。执行如下SQL命令： Sele

答案解析
查询选修了课程号为“C1”的学生的姓名和年龄，若用下列SQL的SELECT语句表达时，错误的是（）。A．SELE

答案解析
在Access中已建立了“学生”表表中有“学号”“姓名”性别”和“入学成绩”等字段。执行如下SQL命令: Sele

答案解析
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

答案解析
Evaluate this SQL statement:SELECT ename sal 12* sal+100 FROM emp;The SAL column stores

答案解析