iteye_13073 2011-07-26 13:30
浏览 686
已采纳

oracle数据库中NOT IN 和 NOT EXISTS为什查不到数据

SELECT GA.ADID, GA.ADNAME
      FROM GAP_AD GA
     WHERE
     exists(SELECT GAP.ADID
              FROM GAP_ADPOSITION GAP
             WHERE GAP.ADPOSITIONSTATUS = '1')
       AND NOT exists(SELECT GAP.ADID
              FROM GAP_ADPOSITION GAP
             WHERE GAP.ADPOSITIONSTATUS = '0'
                OR GAP.ADPOSITIONSTATUS = '2')
为什么查不到数据呢?
SELECT GA.ADID, GA.ADNAME
      FROM GAP_AD GA
     WHERE GA.ADID IN(SELECT GAP.ADID
              FROM GAP_ADPOSITION GAP
             WHERE GAP.ADPOSITIONSTATUS = '1')
       AND GA.ADID NOT IN (SELECT GAP.ADID
              FROM GAP_ADPOSITION GAP
             WHERE GAP.ADPOSITIONSTATUS = '0'
                OR GAP.ADPOSITIONSTATUS = '2')
这个就可以查到
哪位朋友帮帮我

  • 写回答

2条回答 默认 最新

  • cndone 2011-07-26 13:54
    关注

    SELECT GA.ADID, GA.ADNAME
    FROM GAP_AD GA
    WHERE
    exists(SELECT GAP1.ADID
    FROM GAP_ADPOSITION GAP1
    WHERE GAP1.ADPOSITIONSTATUS = '1' and GA.ADID=GAP1.ADID)
    AND NOT exists(SELECT GAP2.ADID
    FROM GAP_ADPOSITION GAP2
    WHERE (GAP2.ADPOSITIONSTATUS = '0'
    OR GAP2.ADPOSITIONSTATUS = '2')AND GA.ADID=GAP2.ADID )

    LZ,have a try!

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 操作系统相关算法中while();的含义
  • ¥15 CNVcaller安装后无法找到文件
  • ¥15 visual studio2022中文乱码无法解决
  • ¥15 关于华为5g模块mh5000-31接线问题
  • ¥15 keil L6007U报错
  • ¥15 webapi 发布到iis后无法访问
  • ¥15 初学者如何快速上手学习stm32?
  • ¥15 如何自动更换布娃娃图片上的衣服
  • ¥15 心理学eprime编程
  • ¥15 arduino esp8266开发