试题详情
- 单项选择题 Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 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.
关注下方微信公众号，在线模考后查看
热门试题
- Which SQL statement
- Which two statements
- Evaluate these two
- Evaluate the set of
- Which statement crea
- You need to perform
- In which case would
- You need to create
- Which view should a
- You need to create a
- The EMPLOYEES table
- Which SELECT stateme
- What is true of usin
- Examinethestructureo
- Which two are true a
- Which four are corre
- Evaluate this SQL s
- Examine the structu
- What is true about u
- Examine the descrip