-
select 1 from b where b.id = a.id和 select 1 from a where b.id = a.id有区别么?
请问他们有区别么?
举个例子:
select * from b where exists (select 1 from a where a.c=b.c)
select * from b where exists (select 1 from b where a.c=b.c)
这两句有区别么?(高效)SELECT * FROM EMP (基础表) WHERE EMPNO > 0 AND EXISTS (SELECT ‘X’ FROM DEPT WHERE DEPT.DEPTNO = EMP.DEPTNO AND LOC = ‘MELB’)
(低效)SELECT * FROM EMP (基础表) WHERE EMPNO > 0 AND DEPTNO IN(SELECT DEPTNO FROM DEPT WHERE LOC = ‘MELB’)
select 1 from b where b.id = a.id和 select 1 from a where b.id = a.id有区别么?
最新推荐文章于 2024-03-12 14:42:37 发布