随笔分类 -  Oracle

摘要：select * From V_XT_XTGNDY start with GNDYXHIN(select GNDYXH From V_XT_XTGNDY WHERE XTMKXH='201' AND GNDYXH IN (SELECT GNDYXH FROM XT_YHFZQX WHERE YHFZBH IN (SELECT YHFZBH FROM XT_YHFZCY WHERE YHRYDM='DBA')))connect by prior FLDYXH=GNDYXH 阅读全文