要查
Oracle-exists用法简单搞懂
Oracle-exists⽤法简单搞懂Exists⽤法可能不太好理解,今天帮助⼤家简单搞懂⽰范语句使⽤exists:select * from T1 where exists(select 1 from T2 where T1.a=T2.a) ;使⽤inselect * from T1 where T1.a in (select T2.a from T2) ;exists ⽤法使⽤exists写法...
Oracle-exists⽤法简单搞懂Exists⽤法可能不太好理解,今天帮助⼤家简单搞懂⽰范语句使⽤exists:select * from T1 where exists(select 1 from T2 where T1.a=T2.a) ;使⽤inselect * from T1 where T1.a in (select T2.a from T2) ;exists ⽤法使⽤exists写法...