Oracle in & exists

iteye_20812

于 2012-11-27 09:38:45 发布

阅读量147

点赞数

分类专栏： Oracle 文章标签： Oracle

本文链接：https://blog.csdn.net/iteye_20812/article/details/82445317

版权

Oracle 专栏收录该内容

84 篇文章

订阅专栏


--IN 转换为 EXISTS 和 NOT EXISTS
SELECT * FROM test2 t2 WHERE t2.col1 IN ('2' );
SELECT * FROM test2 t2 WHERE EXISTS (SELECT * FROM test2 t WHERE t.col1 = t2.col1 AND t.col1 = '2' )
SELECT * FROM test2 t2 WHERE NOT EXISTS (SELECT * FROM test2 t WHERE t.col1 = t2.col1 AND t.col1 != '2')

--NOT IN 转换为 EXISTS 和 NOT EXISTS
SELECT * FROM test2 t2 WHERE t2.col1 NOT IN ('2');
SELECT * FROM test2 t2 WHERE EXISTS (SELECT * FROM test2 t WHERE t.col1 = t2.col1 AND t.col1 != '2' );
SELECT * FROM test2 t2 WHERE NOT EXISTS (SELECT * FROM test2 t WHERE t.col1 = t2.col1 AND t.col1 = '2');