------解决方案-------------------- =all是同时满足
in只要其中之一满足 ------解决方案-------------------- oracle的写法
047的书上就这么一小段
Operator Meaning
IN Equal to any member in the list
ANY Compare value to each value returned by the subquery
ALL Compare value to every value returned by the subquery
给个例子吧,验证=all并不等价于in
select 2 as c1 from dual where 1 in (1,2)
select 2 as c1 from dual where 1 =all (1,2)