【文章內(nèi)容簡介】
employees WHERE employee_id = 143)。 執(zhí)行單行子查詢 ST_CLERK 2600 610 Copyright 169。 Oracle Corporation, 2022. All rights reserved. SELECT last_name, job_id, salary FROM employees WHERE salary = (SELECT MIN(salary) FROM employees)。 在子查詢中使用組函數(shù) 2500 611 Copyright 169。 Oracle Corporation, 2022. All rights reserved. 子查詢中的 HAVING 子句 ? 首先執(zhí)行子查詢。 ? 向主查詢中的 HAVING 子句返回結(jié)果。 SELECT department_id, MIN(salary) FROM employees GROUP BY department_id HAVING MIN(salary) (SELECT MIN(salary) FROM employees WHERE department_id = 50)。 2500 612 Copyright 169。 Oracle Corporation, 2022. All rights reserved. SELECT employee_id, last_name FROM employees WHERE salary = (SELECT MIN(salary) FROM empl