【文件属性】:
文件名称:子查询举例-Oracle数据库Sql语句详解大全 PPT
文件大小:3.47MB
文件格式:PPT
更新时间:2021-04-25 22:11:19
详解大全
子查询举例
SQL> SELECT last_name, first_name, title
2 FROM s_emp
3 WHERE dept_in =
4 (SELECT ID
5 FROM s_dept
6 WHERE name = 'Finance'
7 OR region_id = 2);
ORA-01427:single-row subquery returns more than one row