oracle教学课件尚硅谷宋红康06子查询.ppt

Multiple-Row Subqueries Subqueries that return more than one row are called multiple-row subqueries. You use a multiple-row operator, instead of a single-row operator, with a multiple-row subquery. The multiple-row operator expects one or more values. SELECT last_name, salary, department_id FROM employees WHERE salary IN (SELECT MIN(salary) FROM employees GROUP BY department_id); Example Find the employees who earn the same salary as the minimum salary for each department. The inner query is executed first, producing a query result.