oracle exists函数用法select A.DEPTNO,A.NAME FROM A WHERE EXISTS (SELECT 1 FROM B WHERE A.DEPTNO=B.DEPTNO)中的SELECT 不会是查找是1的值吧?
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/08 19:25:54
![oracle exists函数用法select A.DEPTNO,A.NAME FROM A WHERE EXISTS (SELECT 1 FROM B WHERE A.DEPTNO=B.DEPTNO)中的SELECT 不会是查找是1的值吧?](/uploads/image/z/9513768-48-8.jpg?t=oracle+exists%E5%87%BD%E6%95%B0%E7%94%A8%E6%B3%95select+A.DEPTNO%2CA.NAME+FROM+A+WHERE+EXISTS+%28SELECT+1+FROM+B+WHERE+A.DEPTNO%3DB.DEPTNO%29%E4%B8%AD%E7%9A%84SELECT+%E4%B8%8D%E4%BC%9A%E6%98%AF%E6%9F%A5%E6%89%BE%E6%98%AF1%E7%9A%84%E5%80%BC%E5%90%A7%3F)
x)/JLIUH,.)~ھ
ϧxyjqjNjrk@[BkkgpHFs!D *jeh>ٱ';zlg>d%6y:aMR>nev6;^d*Cg>m|n
[t
г
@Ctzٜ6<;醍/