SELECT COUNT(*) studentQty,
NVL(SUM(CASE WHEN studyStatus = 'Y' AND regStatus = 'Y' THEN 1 ELSE 0 END),0) learningQty,
NVL(SUM(CASE regStatus WHEN 'Y' THEN 1 ELSE 0 END),0) registedQty,
NVL(SUM(CASE WHEN passflag = 'Y' AND regStatus = 'Y' THEN 1 ELSE 0 END),0) passQty
INTO v_studentQty,v_learningQty,v_registedQty,v_passQty
FROM PUBSTUDENTCURRENT s
WHERE EXISTS (SELECT sb.branchID
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
AND termID = v_termID;??请问这里 WHERE EXISTS (SELECT sb.branchID
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
AND termID = v_termID??WHERE EXISTS 是什么意思。。
NVL(SUM(CASE WHEN studyStatus = 'Y' AND regStatus = 'Y' THEN 1 ELSE 0 END),0) learningQty,
NVL(SUM(CASE regStatus WHEN 'Y' THEN 1 ELSE 0 END),0) registedQty,
NVL(SUM(CASE WHEN passflag = 'Y' AND regStatus = 'Y' THEN 1 ELSE 0 END),0) passQty
INTO v_studentQty,v_learningQty,v_registedQty,v_passQty
FROM PUBSTUDENTCURRENT s
WHERE EXISTS (SELECT sb.branchID
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
AND termID = v_termID;??请问这里 WHERE EXISTS (SELECT sb.branchID
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
AND termID = v_termID??WHERE EXISTS 是什么意思。。
解决方案 »
- oracle
- 在oracle 求一个按线路号模糊查询的方法
- PL/SQL DEVELOPER 不能登录是怎么回事呀?在SQL PLUS中是可以的呀,请高手赐教!
- 可以导表到另外的电脑上吗?
- 插入一条记录问题?
- 紧急求救:数据库刚重起过一会,数据库就不能用了,连接不上!
- 应用程序在客户端访问服务器的Oracle,是不是客户端一定要装Oracle Client?
- 请各位前辈多多指导 那里有ORACLE的入门教程下载 有分回报谢谢!!!!!!!!!!!
- 关于UTL_FILE
- 【高分求书】:ORACLE8 PL/SQL程序设计(美:SCOTT URMAN)
- 用asp.net 备份与还原oracle数据库
- 简单sql比较
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
的意思是:EXISTS后面的查询语句若能查到值,则返回真,否则返回假。
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
======================
等效于
WHERE s.branchID in (SELECT sb.branchID
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
)
where exists (select * from test_yixl3 b where a.key = b.t2 and rownum < 2);
意思是:选出表a中,满足a.key = b.t2的记录。
FROM PUBTEACHINGBRANCH sb
WHERE sb.treepath LIKE v_treePath || '%'
AND sb.branchID=s.branchID)
当括号里面的条件成立的时候。