Oracle 9i windows aix区别

最新推荐文章于 2021-04-09 20:18:34 发布

parngoo

最新推荐文章于 2021-04-09 20:18:34 发布

阅读量717

点赞数

CC 4.0 BY-SA版权

分类专栏： DATABASE 文章标签： oracle windows aix join null c

本文链接：https://blog.youkuaiyun.com/parngoo/article/details/241092

DATABASE 专栏收录该内容

10 篇文章

订阅专栏

博客展示了一段Oracle数据库的SQL查询代码，该代码涉及多个表的关联查询，包括子查询和左连接操作，通过筛选条件获取特定区域的数据，并按代码排序。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select c.code code,c.name name from rpt_region_2005_商贸专业 c where regionid in (select regionid from rpt_region_2005_商贸专业 where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' and regiontype=1) and regionid in (select regionid from rpt_rcmember where collectionid=111)) and c.regionid in( select a.regionid from (select regionid from rpt_region_2005_商贸专业 where regionid in (select regionid from rpt_region_2005_商贸专业 where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' and regiontype=1) and regionid in (select regionid from rpt_rcmember where collectionid=111))) a left join (select a.regionid from rpt_rpt_2005_sm a where a.reportFlag='1' and a.reportTemplateID=1802 and a.year=2005 and a.specialityCode='商贸专业' and a.month=1 and a.regionid in (select regionid from rpt_region_2005_商贸专业 where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' and regiontype=1) and regionid in (select regionid from rpt_rcmember where collectionid=111))) b on a.regionid=b.regionid where b.regionid is null) order by c.code