这不是很正常的吗
先执行子查询 然后
select employee_id, last_name,department_id
from employees
where department_id in (60,....)
这样的结果啊
你可以 explain 一下 具体 SQL 看下执行计划
explain plan for
select employee_id, last_name,department_id
from employees
where department_id in (
select department_id
from employees
where last_name like '%u%'
)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…