结果出错:SQL> SELECT employee_id, last_name
2 FROM employees
3 WHERE employee_id =
4 (SELECT employee_id
5 FROM employees
6 WHERE last_name LIKE '%T%');
(SELECT employee_id
*
第 4 行出现错误:
ORA-01427: 单行子查询返回多个行
2 FROM employees
3 WHERE employee_id =
4 (SELECT employee_id
5 FROM employees
6 WHERE last_name LIKE '%T%');
(SELECT employee_id
*
第 4 行出现错误:
ORA-01427: 单行子查询返回多个行
FROM employees
WHERE employee_id in
(SELECT employee_id
FROM employees
WHERE last_name LIKE '%T%');
2 FROM employees
3 WHERE department_id IN
4 (SELECT department_id
5 FROM employees
6 WHERE last_name LIKE '%T%');
这个语法好像没错,输出的结果85条。。
我完成了。。给你分数liao
SQL>spool p6q1.SQL;
sql>SELECT employee_id, last_name
FROM employees
WHERE dept_no in
(SELECT dept_no
FROM department dept JOIN employees emp ON dept.dept_no=emp.dept
and emp.last_name LIKE '%T%');
sql>spool off;