[单选]
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.

（）采取有效措施保证总承包单位质量管理体系在本项目中的持续有效的运行；合同管理。项目总工程师。招标管理。投资管理。 What IBM resource will give you details concerning the total power requirements of a server environment？（） IBM System x and BladeCenter Power Configurator Tool。 IBM Standalone Solutions Configuration Tool （SSCT）。 IBM xREF Sheets。 IBM ServerProve。某小规模商业企业，2001年9月销售百货用品取得收入24000元，则销售额为（）。 22641.51元。 23076.92元。 24000元。 20512.82元。招标人委托招标代理机构办理招标事宜时，受委托的招标代理机构应符合工程建设项目招标代理有关规定的要求。 For NIM to install client machines located in a non-adjacent network， which routing must be defined？（） Boot/install servers will be required on each intermediate network.。 When an install is initiated by the client， routing is only required from the LPAR back to the NIM master.。 When an install is initiated by the NIM master， routing is only required from the NIM master to the client.。 Appropriate network NIM resources need to be defined to the NIM master to allow routing in both directions.。

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? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

[单选] 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? （）

相关题目:

[单选]
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? （）