Oracle 4种等价SQL

iteye_20812

于 2012-11-28 11:15:40 发布

阅读量270

点赞数

CC 4.0 BY-SA版权

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

本文链接：https://blog.youkuaiyun.com/iteye_20812/article/details/82445621

Oracle 专栏收录该内容

84 篇文章

订阅专栏


SELECT COUNT (1) FROM (SELECT k001 FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE NOT EXISTS ( SELECT 1 FROM ( SELECT k003 FROM calb GROUP BY k003) c WHERE k.k001 = c.k003))

SELECT COUNT (1) FROM (SELECT k001 FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE NOT EXISTS ( SELECT k003 FROM calb WHERE k.k001 = k003 GROUP BY k003))

SELECT count (1) FROM (SELECT * FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE k.k001 NOT IN ( SELECT k003 FROM calb c WHERE k.k001 = c.k003 GROUP BY k003))


SELECT count (1) FROM (SELECT * FROM ( SELECT DISTINCT k001 FROM kbib) k
WHERE k.k001 NOT IN ( SELECT DISTINCT k003 FROM calb c WHERE k.k001 = k003))