文件名称:子查询举例-Oracle数据库Sql语句详解大全 PPT
文件大小:3.47MB
文件格式:PPT
更新时间:2024-05-15 15:57:59
详解大全
子查询举例 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