摘要:
1.第一条SQL not in 的写法,不推荐,(有坑) 如果not in 里面 SELECT B.RELEVANT_ID FROM T_COMPANY_DECIDE B where B.PROCESS_STATUS ='newly' and B.IS_DEL = '0' RELEVANT_ID 存 阅读全文
摘要:
SELECT APPROVAL_ID,count(STATION_SNAP_ID) from T_INVEST_STATION_APL where APPROVAL_ID in (select DISTINCT PROJECT_ID from T_ARCHIVE_DETAIL where DATA_ 阅读全文