忘记了 写 from select * from table1 where 姓名 in ('a','b','c')
exist 不是用在这地方的 select * from biao where name in (select name from biao 2 where ) 这样的才用exist 替换
我也想知道难道是这样写 with A as ( select 'a' as col from dual union select 'b' from dual union select 'c' from dual) select * from table1 where exists(select 1 from A where col=姓名 )
select * from table1 where 姓名 in ('a','b','c')
select * from biao where name in (select name from biao 2 where )
这样的才用exist 替换
with A as (
select 'a' as col from dual union
select 'b' from dual union
select 'c' from dual)
select * from table1 where exists(select 1 from A where col=姓名 )
估计楼主就是由次发问的